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

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)

Is there any equivalent key word to "limit" in proc sql?

-Karthik

have you tried the options INOBS, OUTOBS?

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