Hello
data count;
input Age Salary;
datalines;
30 20000
31 20600
32 35000
35 50000
36 50000
31 36500
40 50000
30 80000
36 50000
;
run;
I would like to get output as below
FRQ
30-35 6
36-40 3
Please help me with this.
1. Create a new variable that has your ranges, then run proc freq/tabulate. This you can try on your own.
2. Use a format and run proc freq/tabulate. This is illustrated below.
proc format;
value age_fmt
30 - 35 = '30 to 35'
36 - 40 = '36 to 40';
run;
proc freq data=count;
format age age_fmt.;
table age/out=want;
run;
*output table want is also created if you want a data set;
1. Create a new variable that has your ranges, then run proc freq/tabulate. This you can try on your own.
2. Use a format and run proc freq/tabulate. This is illustrated below.
proc format;
value age_fmt
30 - 35 = '30 to 35'
36 - 40 = '36 to 40';
run;
proc freq data=count;
format age age_fmt.;
table age/out=want;
run;
*output table want is also created if you want a data set;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.