-
Notifications
You must be signed in to change notification settings - Fork 0
/
handout3.2.sas
39 lines (37 loc) · 1.02 KB
/
handout3.2.sas
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
/**If-then**/
/**filling missing values**/
data sportscars;
input model $ year make $ seats color $;
if year < 1975 then status = "classic";
if model = 'Corvette' or model = 'Camaro' then make = "Chevy";
if model = 'Miata' then do;
make = 'Mazda';
seats = 2;
end;
datalines;
Corvette 1955 . 2 black
XJ6 1995 Jaguar 2 teal
Mustang 1966 Ford 4 red
Miata 2002 . . silver
CRX 2001 Honda 2 black
Camaro 2000 . 4 red
;
proc print data = sportscars;
title "Eddy's excellent emporium of used sports cars";
run;
/**Grouping obs**/
data homeimprovements;
input owner $ 1-7 description $ 9-33 cost;
if cost = . then costgroup = 'missing'; /**create a column of costgroup labels**/
else if cost < 2000 then costgroup = 'low';
else if cost < 10000then costgroup = 'medium';
else costgroup = 'high';
datalines;
Bob kitchen cabinet face-lift 1253.00
Shirley bathroom addition 11350.70
Silvia paint exterior .
Al backyard gazebo 3098.63
;
proc print data = homeimprovements;
title 'home improvement cost groups';
run;