BookmarkSubscribeRSS Feed
cjohnson
Obsidian | Level 7
I am trying to run a simple proc sort, and if I add the descending option, it errors:

14 PROC SORT DATA=GOVERNING_CLASS;
15 BY LR descending;
_
22
ERROR 22-322: Syntax error, expecting one of the following: a name, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_.
16 RUN;
ERROR: Variable NAME not found.


However, this runs fine:

PROC SORT DATA=GOVERNING_CLASS;
BY LR;
RUN;

Any ideas? I am running SAS 9.1, EG 4.1, and just installed the newest hotfix for errors.

Thanks,
Chris
Christopher Johnson
www.codeitmagazine.com
2 REPLIES 2
data_null__
Jade | Level 19
The keyword DESCENDING goes before the variable that you want to sort descending.
cjohnson
Obsidian | Level 7
Thanks!!!
Christopher Johnson
www.codeitmagazine.com

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 7394 views
  • 2 likes
  • 2 in conversation