Can I use ROWNUM Pseudo column in proc sql? like other database statement?
eg. PROC SQL;
SELECT * FROM employees WHERE ROWNUM < 11;
QUIT;
No, rownum is a database specific item, not part of ANSI SQL. You can code it simply in datastep.
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;
No, rownum is a database specific item, not part of ANSI SQL. You can code it simply in datastep.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.