Proc sql: limit


Dark Knight
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?

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)

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;


the above code gives only first 10 observations.