topic Re: Proc surveyselect: How do I select 100 random people with all of their rows to be included? in SAS Programming

Proc surveyselect: How do I select 100 random people with all of their rows to be included?

awardell — Wed, 03 Nov 2021 16:01:09 GMT

Hello,

I have a dataset where individuals have observations across multiple rows. Patients are identified by their ID variable. Can I use proc surveyselect to randomly sample 100 of these unique IDs and then keep all of the rows that are tied to that id? It is almost like cluster sampling where the patient's ID is the cluster and we want to keep all of the individuals in that "cluster". I was having trouble finding anything like this in the documentation for proc surveyselect. If it is not possible to do with surveyselect, how can I do it using a different method (proc sql perhaps)?

This is what I've tried. I have also considered trying the selectall option, but that didn't work for me.

proc surveyselect data = data_set method = SRS
  sampsize = 100 seed = 12345 out = sample_ds;
  id _all_;
  strata id;
run;

Thank you for any help you can provide!

Re: Proc surveyselect: How do I select 100 random people with all of their rows to be included?

Watts — Wed, 03 Nov 2021 15:58:56 GMT

You can use the SAMPLINGUNIT | CLUSTER statement in PROC SURVEYSELECT to select patient IDs instead of observations. For example, add

samplingunit patientID;

proc surveyselect data = data_set method = SRS
  sampsize = 100 seed = 12345 out = sample_ds;
  id _all_;
  strata sart_id;
  samplingunit patientID;
run;

Re: Proc surveyselect: How do I select 100 random people with all of their rows to be included?

awardell — Wed, 03 Nov 2021 16:07:19 GMT

Thank you so much!