Hello all,
I want the table, which shows frequency of observation in ascending order
Here is my output
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
DATA STATE (drop = i);
INFORMAT STATE1-STATE5 $2.;
INPUT ID STATE1-STATE5;
array vars[*] _character_;
do i=1 to dim(vars);
if vars[i]= 'XX' then vars[i]= ' ';
end;
DATALINES;
1 NY NJ PA TX GA
2 NJ NY CA XX XX
3 PA XX XX XX XX
;
proc
print data=state;
proc
freq data=state;
table STATE1-STATE5/ nocum nopercent;
run;
here is my log
save the output and sort it
PROC freq data = &syslast;
tables ... /noprint
out = list_values;
run;
PROC sort data = &syslast;
by count;
PROC print;
run;
Ron Fehd out-data maven
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.