topic Reading specified Observations in SAS Procedures

Reading specified Observations

Siddhartha — Fri, 22 Oct 2010 23:24:25 GMT

I am having a dataset with 100 observations.
I want to read only 5th,19th,21st records using data step and proc sql.
How can I do this?

Regards,
Siddhartha

Re: Reading specified Observations

Patrick — Sat, 23 Oct 2010 00:32:14 GMT

data step:
if _n_ in (5,19,21);

SQL:
Using a data step you will first have to add a obsnum variable to your data set, i.e. obsnum=_n_;
Then in the SQL you use: where obsnum in (5,19,21).

Theoretically monotonic() could be used as well but Cynthia made in another tread a very clear point that this is an undocumented function which also has some known issues and as such should not be used at all.

Re: Reading specified Observations

sbb — Sat, 23 Oct 2010 03:54:38 GMT

With the DATA step approach, review the SAS Language Dictionary DOC for using a SET with the POINT= parameter.

Scott Barry
SBBWorks, Inc.