topic Re: How to have a varying sample size in PROC surveyselect. in SAS Procedures

How to have a varying sample size in PROC surveyselect.

Sotarkadin — Wed, 09 Mar 2016 17:59:54 GMT

I am currently using PROC surveyselect to pull a random sample from a data set using this code:

proc surveyselect data= out.care_statement_all_q&rptqtr. 
method=srs n=60 out=out.care_statement_q&rptqtr.; 
run;

Is there a way to set the size as a range. Every run the user would like a varying sample size between 60-70. This is part of an automated process so I would like there to be no manual involvement.

Re: How to have a varying sample size in PROC surveyselect.

ballardw — Wed, 09 Mar 2016 18:17:48 GMT

What environment is the user using to run the code? Base SAS, Enterprise Guide, something else?

Re: How to have a varying sample size in PROC surveyselect.

Sotarkadin — Wed, 09 Mar 2016 18:28:19 GMT

Sorry for the lack of details. It is currently being run in SAS EG on our companies UNIX envrionment. I am new to SAS programming and not sure all the correct terms. It is executed from an auto file that kicks off automatically.

Re: How to have a varying sample size in PROC surveyselect.

PGStats — Wed, 09 Mar 2016 18:32:30 GMT

Create 11 fake strata in your data

data fakeStrataCare;
set out.care_statement_all_q&rptqtr.;
do stratum=60 to 70;
	output;
	end;
run;

proc sort data=fakeStrataCare; by stratum; run;

and call proc surveyselect with a different sample size for each stratum

proc surveyselect data= fakeStrataCare 
method=srs n=(60 61 62 63 64 65 66 67 68 69 70) out=out.care_statement_q&rptqtr.; 
strata stratum;
run;

(untested)

Re: How to have a varying sample size in PROC surveyselect.

Ksharp — Thu, 10 Mar 2016 01:56:18 GMT

Make a random macro variable :

%let n=%sysevalf(%sysfunc(rand(uniform))*10+60,i);
%put NOTE: n=&n;

proc surveyselect ............... n=&n ........

Re: How to have a varying sample size in PROC surveyselect.

Sotarkadin — Thu, 10 Mar 2016 19:49:40 GMT

Thank you so much Ksharp. This worked perfectly and is simple for what I am doing. Could you explain it a bit so if I never needed to use this again but for varying sample size. Like if I need between 30-40 how would I change the numbers.

Re: How to have a varying sample size in PROC surveyselect.

Ksharp — Fri, 11 Mar 2016 01:13:35 GMT

%let n=%sysevalf(%sysfunc(rand(uniform))*10+30,i);

int(rand('uniform')*10) will generate the random number 0,1,2,3,4,5,6,7,8,9

here 10 is the range between 30 and 40 .

here 30 is the base of range(or left value of range) .