proc surveyselect random sample

Justin9 — Fri, 01 Jul 2022 15:33:21 GMT

Hi,

I'm looking to extract 41,000 accounts out of my 200,000 account dataset using random sampling. I want the random sampling to be done based on the proportions of my 'band' variable, which has the following distribution:

0-<2441 makes up 15.63%

2449-20001 makes up 80.04%

200001-High makes up 4.33%

Please can someone tell me what code I could use to randomly get the 41,000 accounts I want based on the proportions (it's fine if the proportions are slightly different, as long as it equals 41,000 accounts)? In my example, the random sampling would mean about 6,150 in the 0-<2441 band, about 32,800 accounts in the 2449-20001 band, and about 1,640 accounts in the 200001-High band. I've seen proc surveyselect can be used (and I think proc sort of my accounts by 'band' might need to be done beforehand), but I'm not sure how to write the code to get what I require.

Re: proc surveyselect random sample

sbxkoenk — Fri, 01 Jul 2022 15:59:54 GMT

You need proportional allocation as done here:

proc surveyselect data=Customers n=41000
                  out=SampleCust;
   strata BAND / alloc=prop ;
run;

Koen

Re: proc surveyselect random sample

Justin9 — Fri, 01 Jul 2022 17:17:24 GMT

It worked, so thanks a lot for your code!

topic Re: proc surveyselect random sample in SAS Programming

proc surveyselect random sample

Re: proc surveyselect random sample

Re: proc surveyselect random sample