topic Re: proc freq descending outcum in SAS Programming

proc freq descending outcum

superbug — Wed, 25 Mar 2020 17:02:01 GMT

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!

Re: proc freq descending outcum

yabwon — Wed, 25 Mar 2020 17:06:09 GMT

Hi,

read the doc about descending option:

proc sort data=want; 
by descending CUM_FREQ ; 
run

All the best

Bart

Re: proc freq descending outcum

superbug — Wed, 25 Mar 2020 17:09:47 GMT

@yabwon

thanks much for the help!

Re: proc freq descending outcum

ballardw — Wed, 25 Mar 2020 17:28:56 GMT

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.

Re: proc freq descending outcum

superbug — Wed, 25 Mar 2020 18:16:24 GMT

@ballardw

Thanks much for your suggestion!

I noticed this option before I posted.