topic nosorted in SAS Programming

nosorted

Ronein — Sun, 13 Feb 2022 08:57:48 GMT

Hello

Why nosorted is not working here?

28 by col1 col2 nosorted.;
_________
22
201
ERROR 22-322: Syntax error, expecting one of the following: a name, -, :, ;, DESCENDING, GROUPFORMAT, NOTSORTED, _ALL_,
_CHARACTER_, _CHAR_, _NUMERIC_.

data have;
input col1 col2;
datalines;
101 20
101 20
101 15
;
run;
data want4;
set have;
by col1 col2 nosorted;
if first.col2 then seq_id=1;
else if first.col2 then seq_id+1;
run;

Re: nosorted

Amir — Sun, 13 Feb 2022 09:20:13 GMT

Hi @Ronein,

It looks like there is a "t" missing, try notsorted, as it appears in the error message.

Kind regards,

Amir.

Re: nosorted

Kurt_Bremser — Sun, 13 Feb 2022 12:48:01 GMT

Just read the log, it already tells you:

28 by col1 col2 nosorted.;
_________
22
201
ERROR 22-322: Syntax error, expecting one of the following: a name, -, :, ;, DESCENDING, GROUPFORMAT, NOTSORTED, _ALL_,
_CHARACTER_, _CHAR_, _NUMERIC_.

And a Google search (Maxim 6) for "sas nosorted" will reveal the correct spelling in the first result.