proc format; value $routes 'Route1' = 'Zone 1' 'Route2' - 'Route4' = 'Zone 2' 'Route5' - 'Route7' = 'Zone 3' ' ' = 'Missing' other = 'Unknown'; value $dest 'AKL','AMS','ARN','ATH','BKK','BRU', 'CBR','CCU','CDG','CPH','CPT','DEL', 'DXB','FBU','FCO','FRA','GLA','GVA', 'HEL','HKG','HND','JED','JNB','JRS', 'LHR','LIS','MAD','NBO','PEK','PRG', 'SIN','SYD','VIE','WLG' = 'International' 'ANC','BHM','BNA','BOS','DFW','HNL', 'IAD','IND','JFK','LAX','MCI','MIA', 'MSY','ORD','PWM','RDU','SEA','SFO' = 'Domestic'; value revfmt . = 'Missing' low - 10000 = 'Up to $10,000' 10000 <- 20000 = '$10,000+ to $20,000' 20000 <- 30000 = '$20,000+ to $30,000' 30000 <- 40000 = '$30,000+ to $40,000' 40000 <- 50000 = '$40,000+ to $50,000' 50000 <- 60000 = '$50,000+ to $60,000' 60000 <- HIGH = 'More than $60,000'; run;
10000<-20000
indicates
that the first value is not included in the range)
Value
|
Label
|
---|---|
Jan - Mar
|
1st Quarter
|
Apr - Jun
|
2nd Quarter
|
Jul - Sep
|
3rd Quarter
|
Oct - Dec
|
4th Quarter
|
Jan - Jun
|
First Half of Year
|
Jul- Dec
|
Second Half of Year
|
proc format;
value dates (multilabel)
'01jan2000'd - '31mar2000'd = '1st Quarter'
'01apr2000'd - '30jun2000'd = '2nd Quarter'
'01jul2000'd - '30sep2000'd = '3rd Quarter'
'01oct2000'd - '31dec2000'd = '4th Quarter'
'01jan2000'd - '30jun2000'd = 'First Half of Year'
'01jul2000'd - '31dec2000'd = 'Second Half of Year';
run;
proc tabulate data = sasuser.sale2000 format = dollar15.2;
class Date / mlf;
var RevCargo;
table Date, RevCargo*(mean median);
format Date dates.;
run;