Select Top N records 1

[DonaZ]

Hi
How do you select the top N records using Proc SQL in SAS?

Thank you in advance for your time.

 

[ChrisW75]

You can't really, not that I'm aware of.
However, you can put an OBS= dataset option onto the input dataset...

proc sql;
  create table blah2 as
  select *
  from blah1(obs=10)
  ;
quit;

Is that what you're after?

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.