Proc sql: limit

vinux

Dark Knight
#2
hi all,

does any one have an idea about using of the keyword "LIMIT" in proc sql. this keyword can be used in mysql queries. can we use the same here?

-Karthik
Nope, keyword LIMIT is not a part of proc sql.

It may work in pass through SQL(using connection and running the queries directly with a database)
 
#5
hi

i have tried outobs and it restricts the number of observations.

i found another way to limit the observations: using the function "monotonic"

proc sql;

select *,monotonic() as recno from table_old having recno<11;

quit;

the above code gives only first 10 observations.

-Karthik