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
ALLOC=PROP appeared in SAS 9.2 Which version of SAS are you using?
PG
we are using 9.1. any other suggestion?
How do you define optimal in this sense?
I am interested in a procedure which gives sample size recommendation based on population size. is POWER procedure the one to consider?
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?).
Thank you very much for all your suggestions. We will be looking into Power procedure
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.