Search the site...
SASCRUNCH TRAINING
Home
Member's Area
How to Start
SAS Interface
Creating a Data Set
Practical SAS Training Course
SAS Certified Specialist Training Program
Proc SQL Course
Introduction to Time Series Analysis
SAS Project Training Course
Full Training / Membership
Sign up
About us
Contact us
Home
Member's Area
How to Start
SAS Interface
Creating a Data Set
Practical SAS Training Course
SAS Certified Specialist Training Program
Proc SQL Course
Introduction to Time Series Analysis
SAS Project Training Course
Full Training / Membership
Sign up
About us
Contact us
Sentry Page Protection
Please Wait...
Exercise (3-4)
Copy and run the code from the yellow box below:
data car_list1; infile datalines dsd; input Make : $20. Model : $40. Weight Length; datalines; Nissan,Sentra 1.8 4dr,2513,178 BMW,325xi 4dr,3461,176 Chrysler,Concorde LXi 4dr,3548,208 Lexus,IS 300 4dr auto,3285,177 GMC,Sonoma Crew Cab,4083,208 Honda,Accord EX V6 2dr,3294,188 Jaguar,XJ8 4dr,3803,200 Mercedes-Benz,CLK320 coupe 2dr (convertible),3770,183 Mercury,Sable LS Premium 4dr,3315,200 Audi,S4 Quattro 4dr,3825,179 BMW,330i 4dr,3285,176 Mercedes-Benz,C240,3470,179 Jaguar,XK8 coupe 2dr,3779,187 Mazda,RX-8 4dr manual,3029,174 Cadillac,CTS VVT 4dr,3694,190 Ford,Focus ZX5 5dr,2691,168 Volkswagen,Jetta GLI VR6 4dr,3179,172 Kia,Rio 4dr manual,2403,167 Jaguar,XJR 4dr,3948,200 Mercury,Grand Marquis LS Ultimate 4dr,4052,212 Toyota,Corolla S 4dr,2524,178 Mazda,Mazda3 i 4dr,2696,178 Kia,Spectra GS 4dr hatch,2686,178 Infiniti,G35 Sport Coupe 2dr,3416,182 Mercedes-Benz,E320,3966,190 Ford,Focus LX 4dr,2606,168 Kia,Spectra 4dr,2661,178 Audi,RS 6 4dr,4024,191 Subaru,Legacy L 4dr,3285,184 Chrysler,PT Cruiser GT 4dr,3217,169 Lexus,GS 430 4dr,3715,189 Cadillac,Deville DTS 4dr,4044,207 Dodge,Ram 1500 Regular Cab ST,4542,208 Mercedes-Benz,C320 4dr,3450,178 Subaru,Outback Limited Sedan 4dr,3495,184 Audi,A4 3.0 convertible 2dr,3814,180 Ford,Focus SE 4dr,2606,168 Mazda,B4000 SE Cab Plus,3571,203 Honda,Pilot LX,4387,188 Lincoln,Town Car Ultimate 4dr,4369,215 ; run; data car_list2; infile datalines dsd; input Make : $20. Model : $40. Weight Length; datalines; Chrysler,PT Cruiser Limited 4dr,3105,169 BMW,330xi 4dr,3483,176 BMW,M3 coupe 2dr,3415,177 Volkswagen,Passat W8 4MOTION 4dr,3953,185 Mercedes-Benz,CL500 2dr,4085,196 Mercedes-Benz,SL55 AMG 2dr,4235,179 Honda,Insight 2dr (gas/electric),1850,155 Dodge,Dakota Club Cab,3829,219 Scion,xA 4dr hatch,2340,154 Volvo,S80 T6 4dr,3653,190 Mercedes-Benz,C240 4dr,3360,178 Chevrolet,TrailBlazer LT,4425,192 Nissan,Sentra SE-R 4dr,2761,178 Saturn,VUE,3381,181 Hyundai,XG350 L 4dr,3651,192 Hyundai,Tiburon GT V6 2dr,3023,173 Mercury,Grand Marquis GS 4dr,4052,212 Jaguar,S-Type 4.2 4dr,3874,192 Nissan,Maxima SE 4dr,3473,194 GMC,Safari SLE,4309,190 Audi,A6 3.0 4dr,3561,192 Mercury,Grand Marquis LS Premium 4dr,4052,212 Ford,Mustang 2dr (convertible),3290,183 Nissan,Sentra 1.8 S 4dr,2581,178 Acura,TL 4dr,3575,186 Volkswagen,Touareg V6,5086,187 Suzuki,Forenza S 4dr,2701,177 Volkswagen,Phaeton W12 4dr,5399,204 Audi,A6 3.0 Quattro 4dr,3880,192 Chrysler,300M Special Edition 4dr,3650,198 Hyundai,Elantra GT 4dr hatch,2698,178 Kia,Optima LX 4dr,3281,186 Mazda,RX-8 4dr automatic,3053,174 Mercury,Sable GS 4dr,3308,200 Mercedes-Benz,C240 4dr,3360,178 Dodge,Neon SXT 4dr,2626,174 Volkswagen,Phaeton 4dr,5194,204 Volvo,S60 T5 4dr,3766,180 Volkswagen,GTI 1.8T 2dr hatch,2934,168 Nissan,Altima S 4dr,3039,192 Subaru,Outback,3430,187 GMC,Sierra Extended Cab 1500,4548,230 Dodge,Neon SE 4dr,2581,174 Honda,Accord LX V6 4dr,3349,190 Ford,Crown Victoria 4dr,4057,212 Lexus,LS 430 4dr,3990,197 Ford,Ranger 2.3 XL Regular Cab,3028,188 Nissan,Xterra XE V6,3760,178 Ford,F-150 Regular Cab XL,4788,211 Dodge,Durango SLT,4987,201 ; run;
The code above creates two data sets: CAR_LIST1 and CAR_LIST2.
Combine the two data sets by interleaving them.
Next