topic 20 records for each country code in SAS Programming

20 records for each country code

SASPhile — Fri, 30 Nov 2012 14:55:13 GMT

There are 13 mil records in a dataset. and there is column country_cd. I need to pull 20 records for each country_cd i.e

country_cd list that i'm interested is 001, 840, 124, 875.For each of this country code I need get 20 records.

Any help is appreciated.

Haikuo — Fri, 30 Nov 2012 15:57:43 GMT

Hi,

If I understand you correctly, the following code may get you to start:

data _w1/view=_w1;

set have (where=(country_cd in ('001','840','124','875')));

run;

proc sort data=_w1;

by country_cd;

run;

data want;

do _n_=1 by 1 until (last.country_cd);

set _w1;

by country_cd;

if _n_<=20 then output;

end;

run;

Haikuo

SASPhile — Fri, 30 Nov 2012 16:12:03 GMT

I used somethng like this:

proc sql;

create table outdata.cntry_20 as

select * from outdata._master_v1(obs=20) where ADR_CTRY_CD='000'

union all

select * from outdata._master_v1(obs=20) where ADR_CTRY_CD='840'

union all

select * from outdata._master_v1(obs=20) where ADR_CTRY_CD='344'

union all

select * from outdata._master_v1(obs=20) where ADR_CTRY_CD='392'

union all

select * from outdata._master_v1(obs=20) where ADR_CTRY_CD='076';

quit;