- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 11-17-2010 08:54 AM
(7776 views)
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
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
www.codeitmagazine.com
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
The keyword DESCENDING goes before the variable that you want to sort descending.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks!!!
Christopher Johnson
www.codeitmagazine.com
www.codeitmagazine.com