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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.