topic Re: Selecting limited rows in SAS Programming

Selecting limited rows

USP2405 — Tue, 04 Aug 2015 17:09:26 GMT

Hi,

I have 1000 records data and need to select certain number of rows from the data.

for e.g - I want to extract observation/row no . 5, 21, 58, 84, 134, 367, 412, 498, 578, 634.........

Please suggest.

Re: Selecting limited rows

ballardw — Tue, 04 Aug 2015 17:15:11 GMT

data want;

set have;

if _n_ in (5,21,58,84,134);

run;

Re: Selecting limited rows

Narasimha_Kulkarni33 — Tue, 04 Aug 2015 17:16:41 GMT

Hi,

If there is no pattern in the number of rows you want to extract, then you have to conditionally check whether _n_ system variable hold required row numbers. If yes then extract.

If _n_ in (5,21,....);

Re: Selecting limited rows

KrisNori — Wed, 05 Aug 2015 12:36:30 GMT

Generate a data set with 1000 numbers.

Data Random_data;

do num = 1 to 1000;

OUTPUT;

end;

RUN;

Use POINT= option to read only those records from the above data set - Random_data;

Data random;

do i= 5, 21, 58, 84, 134, 367, 412, 498, 578, 634;

SET Random_data POINT=i;

OUTPUT;

end;

STOP;

RUN;

Re: Selecting limited rows

USP2405 — Thu, 06 Aug 2015 05:05:25 GMT

Thank you all for your suggestions.