How to randomly select responses with replacement, but evenly distributed across groups?

[t75wez1]

Hi,

I am looking at a survey data set of 694 responses who are in 12 different age groups but the distribution of responses heavily skew to younger age groups.

My question is how to randomly select those 694 responses with replacement, but evenly distributed across 12 age groups?

Many thanks,

Ethan

[PGStats]

Use stratified random sampling. Proc surveyselect does that:

/* Prepare some test data */
data heart;
set sashelp.heart;
if ageAtDeath > 34;
ageGroup = round(ageAtDeath, 10);
run;

title "Population frequencies";
proc freq data=heart;
table ageGroup;
run;

/* Data must be sorted by strata, prior to random sampling */
proc sort data=heart; by ageGroup; run;

proc surveyselect data=heart sampsize=10 out=sample noprint;
strata ageGroup;
run;

title "Sample frequencies";
proc freq data=sample;
table ageGroup;
run;

[t75wez1]

Thanks PGStats, What if I want to have the sample size greater than 20 in "proc surveyselect". so some of responses could be re-selected for certain age groups.

How to make a change in your code below?

[PGStats]

You can request unrestricted random sampling (sampling with replacement) by specifying options METHOD=URS OUTHITS in the proc surveyselect statement. This will allow sampling sizes greater than the strata sizes but will allow replicates in every stratum.

[t75wez1 · Accepted solution]

Hi PGStats,

It works perfectly. Thanks a ton for the sublime solution you provided.

[FreelanceReinh]

Hello @t75wez1,

Glad to see that PGStats's solution worked for you. Then it would be fair and help later readers if you marked his helpful reply as the accepted solution, not your own "thank you" post. Could you please change that? It's very easy: Select his post as the solution after clicking "Not the Solution" in the option menu (see icon below) of the current solution.

[t75wez1]

Hello FreelanceRehard,

I got the email stated that "Great job! You marked your answer to a question as an accepted solution!"

and I don't see "Not the solution" option from "Show option menu" you indicated.

Thank you.

[FreelanceReinh]

The item "Not the solution" is only available in the option menu of the current solution (i.e., your post with the green background color).