PROC SQL.

[katkarparam]

Can I use ROWNUM Pseudo column in proc sql?  like other database statement?

eg.    PROC SQL;

            SELECT * FROM employees WHERE ROWNUM < 11;

         QUIT;

[Kurt_Bremser]

Much easier done in a data step:

data want;
set have (obs=10);
run;

SQL either takes much more coding:

proc sql;
create table want (drop=count) as
select *, monotonic() as count
from sashelp.class
having count < 11;
quit;

or will create a WARNING:

proc sql outobs=10;
create table want as select * from sashelp.class;
quit;

Edit:

to simply create a row number, use this data step:

data want;
set have;
rownum = _n_;
run;

[RW9 · Accepted solution]

No, rownum is a database specific item, not part of ANSI SQL.  You can code it simply in datastep.