proc freq descending outcum

[superbug]

Hello,

I used the following SAS code to get cumulative count

proc freq data=have ;
tables pass2013/OUTCUM list missing out=want;
run;

then I used the following to sort by descending of cumulative count

proc sort data=want; by CUM_FREQ descending; run;

But got error message of "Variable NAME not found" as following

ERROR: Variable NAME not found.

ERROR 22-322: Syntax error, expecting one of the following: a name, _ALL_, _CHARACTER_, _CHAR_,
_NUMERIC_.

Please help.

thanks!

[yabwon · Accepted solution]

Hi, 

read the doc about descending option:

proc sort data=want; 
by descending CUM_FREQ ; 
run

All the best

Bart

[superbug]

@yabwon 

thanks much for the help!

[ballardw]

You may want to consider adding the option ORDER=FREQ to the Proc Freq. The output will be sorted by descending frequency of the variable. That is not exactly what your current output creates but it may be of interest.

[superbug]

@ballardw 

Thanks much for your suggestion!

I noticed this option before I posted.