topic Re: How to set sampsize as count of table/4 in SAS Procedures

How to set sampsize as count of table/4

sayginf — Wed, 28 Aug 2013 11:41:53 GMT

Hi I want to get a random sample from a table but I want output number as %25 of the table count

here is the code:

proc surveyselect data=temp.tableA method = urs sampsize = ???

rep=1 seed=12345 out=temp.sonuc out=outhits;

id bayi pos key msisdn;

run;

proc print data = temp.sonuc noobs;

run;

how can I put sampsize=count(tableA)/4

or the %25

for example table has 1000 row

but I need output number 250

but I do not put it hard coded

it must calculate the count of table then it must take 1/4 of the numberr

Re: How to set sampsize as count of table/4

Scott_Mitchell — Wed, 28 Aug 2013 11:53:58 GMT

You could create a macro variable based on the number of obs in the dataset using the following.

%LET DSID = %SYSFUNC(OPEN(SASHELP.CLASS));

%LET NUMOBS = %SYSFUNC(ATTRN(&DSID.,NOBS));

%LET SAMP = %SYSEVALF(&NUMOBS./4,CEIL);

%LET RC = %SYSFUNC(CLOSE(&DSID));

%PUT *****************************&NUMOBS. &SAMP.;

Edited to make use of the CEIL modifier.

Re: How to set sampsize as count of table/4

Keith — Wed, 28 Aug 2013 11:56:46 GMT

You need to use the SAMPRATE option instead of SAMPSIZE.

proc surveyselect data=temp.tableA method = urs samprate = 0.25

Re: How to set sampsize as count of table/4

data_null__ — Wed, 28 Aug 2013 12:00:48 GMT

Can't you SAMPRATE= option.

SAMPRATE=r

RATE=r

specifies the sampling rate, which is the proportion of units to select for the sample. The sampling rate r must be a positive number. You can specify r as a number between 0 and 1. Or you can specify r in percentage form as a number between 1 and 100, and PROC SURVEYSELECT converts that number to a proportion. The procedure treats the value 1 as 100% instead of 1%.

Re: How to set sampsize as count of table/4

sayginf — Wed, 28 Aug 2013 12:18:55 GMT

I made what you said but it brings to me not exactly 1/4 of the table

for example my table has 425019 row

but the code brings to me 94239 row

I changed the extra features from the code but it did not change

proc surveyselect data=temp.tableA method = urs samprate = 0.25

seed=12345 out=temp.sonuc ;

run;

Re: How to set sampsize as count of table/4

sayginf — Wed, 28 Aug 2013 12:20:00 GMT

thank you but I do not know how to write macro yet

but I will learn in near future

Re: How to set sampsize as count of table/4

Keith — Wed, 28 Aug 2013 12:38:51 GMT

This is due to the sampling method you are using (URS), which allows replacement (i.e. it can select the same observation more than once). The output dataset will only contain the unique values, so any duplicate observations have been dropped. If you change the method to SRS then you will always get 25% of the observations each time.

I suggest you read up on the PROC SURVEYSELECT documentation, this gives you all the answers to your questions.

Re: How to set sampsize as count of table/4

sayginf — Wed, 28 Aug 2013 12:50:37 GMT

Thank you very much,

I will read of course but this was urgent.

Re: How to set sampsize as count of table/4

data_null__ — Wed, 28 Aug 2013 13:27:55 GMT

I would never trust an urgent need to the whims of a user forum.

Re: How to set sampsize as count of table/4

Keith — Wed, 28 Aug 2013 13:44:29 GMT

Likewise I would never run some SAS code without understanding what it was doing!