If there is an option similar to what we have in DB where we can limit the number of observation for a SQL query it will be a nice thing to have.
Create table test as
Create table test1 as
Is this for pass through to a DB or SAS native SQL?
If the later then it exists:
from temp (obs= 20);
Thanks for your suggestion but i was looking for more about an option similar to what we have in Databases, where we can limit row for a particular query.
As in the above case it will limit the records for the select query but in case there are joins involved it will not limit the output for the join result; sorry for not presenting the example in a correct way.
i guess there is an option that works at the procedure level for limiting the observations but if there are multiple queries in a single PROC SQL then i do not know how to limit the observations for a particular query results.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.