topic Re: Sorting Error in SAS Programming

Sorting Error

harveysarah0 — Wed, 26 Feb 2020 02:22:11 GMT

76 PROC SORT Bbq;
---
22
202
ERROR 22-322: Syntax error, expecting one of the following: ;, ASCII, BUFFNO, DANISH, DATA, DATECOPY,
DETAILS, DIAG, DUPOUT, EBCDIC, EQUALS, FINNISH, FORCE, IN, ISA, L, LEAVE, LIST,
MESSAGE, MSG, NATIONAL, NODUP, NODUPKEY, NODUPKEYS, NODUPLICATE, NODUPLICATES,
NODUPREC, NODUPRECS, NODUPS, NOEQUALS, NORWEGIAN, NOTHREADS, NOUNIKEY, NOUNIKEYS,
NOUNIQUEKEY, NOUNIQUEKEYS, NOUNIQUEREC, NOUNIQUERECS, NOUNIREC, NOUNIRECS, OSA, OUT,
OVERWRITE, PAGESIZE, PRESORTED, PSIZE, REVERSE, SIZE, SORTSEQ, SORTSIZE, SORTWKNO,
SWEDISH, T, TAGSORT, TECH, TECHNIQUE, TESTHSI, THREADS, UNIOUT, UNIQUEOUT, WKNO,
WORKNO.
ERROR 202-322: The option or parameter is not recognized and will be ignored.
77 By descending Price
78 RUN;

This comes up when I am trying to answer this question.

Sort your merged SAS data set by price of a quarter rack of ribs, from cheapest to

most expensive. Print the resulting table and present it (properly titled) in your

solutions.

This is the code I am trying to input:

PROC SORT Bbq;
By descending Price
RUN;

Re: Sorting Error

Patrick — Wed, 26 Feb 2020 02:30:04 GMT

Look at the code you've posted in your other post here. That should work.

Valid syntax would be:

PROC SORT data=Bbq;
By descending Price;
RUN;

Re: Sorting Error

Astounding — Wed, 26 Feb 2020 02:37:51 GMT

One more change to make: take out the word DESCENDING.

The problem asks for cheapest to most expensive, which would require lowest to highest price.

You won't get an error by adding DESCENDING, but you won't get the right result.

Re: Sorting Error

harveysarah0 — Wed, 26 Feb 2020 02:48:16 GMT

Do I put lowest to highest instead of descending?

Re: Sorting Error

V_27 — Wed, 26 Feb 2020 03:04:34 GMT

No. Just remove descending from BY statement. It will automatically sort from lowest to highest

Re: Sorting Error

ed_sas_member — Wed, 26 Feb 2020 08:30:14 GMT

Hi @harveysarah0

There is no need to specify ascending, as it is the default sorting:

proc sort data=Bbq;
	by Price;
run;