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!
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;
Try PROC SURVEYSELECT
Look at the strata statement and the Secondary input dataset feature of proc surveyselect.
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.