topic random sample from another data set in SAS Programming

random sample from another data set

at803535 — Sun, 10 Dec 2017 13:44:55 GMT

I have no idea how to get started on this. I was thinking of creating an array with DO LOOPS to get the observation but not sure

where to start it as I am very new to SAS.

Please let me know if you need anything else. I will be attaching a sample of my code soon.

Thanks!

Re: random sample from another data set

Reeza — Fri, 08 Dec 2017 02:13:53 GMT

Try PROC SURVEYSELECT

Re: random sample from another data set

PGStats — Fri, 08 Dec 2017 05:35:10 GMT

Look at the strata statement and the Secondary input dataset feature of proc surveyselect.

Re: random sample from another data set

PeterClemmensen — Fri, 08 Dec 2017 09:34:07 GMT

I would probably do this in two distinct PROC SURVEYSELECT steps like below.

I made example data set from sashelp.cars and made arbitrary mileage categories for demonstration purposes

data cars;
	set sashelp.cars;
	length mileage $20;
	if mpg_city<16 then mileage='Bad';
	else if 16<=mpg_city<25 then mileage='Fair';
	else if 25<=mpg_city<30 then mileage='Good';
	else mileage='Excellent';
	do i=1 to 100; output; end;
	drop i;
run;

proc sort data=cars;
	by mileage;
run;

proc surveyselect data=cars out=sample1 method=srs n=200 noprint;
	where mileage in ('Bad', 'Excellent');
	strata mileage;
run;

proc surveyselect data=cars out=sample2 method=srs samprate=0.01 noprint;
	where mileage in ('Fair', 'Good');
	strata mileage;
run;

data finalsample;
	set sample1 sample2;
run;