topic Re: PROC SQL. in SAS Programming

PROC SQL.

katkarparam — Wed, 06 Jun 2018 06:46:18 GMT

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 — Wed, 06 Jun 2018 09:08:09 GMT

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 — Wed, 06 Jun 2018 08:17:26 GMT

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