topic Re: Proc survey select in SAS Enterprise Guide

Proc survey select

avatar — Tue, 31 Jul 2012 20:23:28 GMT

I have a dataset (226841 records) having 2 columns(Claim_num and ACCT). there are about 235 ACCT having claims ranging 1 to 24,648)

I would like to get optimal sample size from this set to audit.

proc surveyselect data=cag_out n=100

out=Sample_all_out;

strata cag / ALLOC=PROP nosample;

run;

I getting error

ERROR: Variable PROP not found.

ERROR: Variable NOSAMPLE not found.

ERROR 22-322: Syntax error, expecting one of the following: a name, ;, -, :, DESCENDING, NOTSORTED, _ALL_, _CHARACTER_, _CHAR_,

_NUMERIC_.

ERROR 202-322: The option or parameter is not recognized and will be ignored.

any help is appreciated

Thanks

Re: Proc survey select

PGStats — Tue, 31 Jul 2012 20:44:10 GMT

ALLOC=PROP appeared in SAS 9.2 Which version of SAS are you using?

Re: Proc survey select

avatar — Tue, 31 Jul 2012 20:46:50 GMT

we are using 9.1. any other suggestion?

Re: Proc survey select

ballardw — Tue, 31 Jul 2012 21:25:36 GMT

How do you define optimal in this sense?

Re: Proc survey select

avatar — Wed, 01 Aug 2012 14:02:45 GMT

I am interested in a procedure which gives sample size recommendation based on population size. is POWER procedure the one to consider?

Re: Proc survey select

Doc_Duke — Thu, 02 Aug 2012 15:19:59 GMT

All of the common statistical power/sample size procedures assume an infinite underlying (theoretical) population. Working with fixed populations complicates the estimation. Your 'population' is large enough to be functionally infinite. However, you still need to optimize on something else.

Change your question to something that power works for. Most likely, that would be to get a sufficient precision (s.d.) on an estimator of interest (cost?).

Re: Proc survey select

avatar — Thu, 02 Aug 2012 15:26:03 GMT

Thank you very much for all your suggestions. We will be looking into Power procedure