nosorted

[Ronein]

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;
 

[Amir]

Hi @Ronein,

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

Kind regards,

Amir.

[Kurt_Bremser]

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.