HI all. I am trying to figure out how to write code which will calculate control and sample sizes based off one group of  direct market response rates.  So, I have a list which looks like this: Response Rate 0.647% 2.735% 1.778% 0.252% 1.577% 0.061% 0.354% 0.374% 0.250% 0.192% 0.364% 0.801% 0.674% 1.461% 0.315% 0.468% 1.737% 0.207% 0.162% 0.378% 2.439% 0.400% 2.305% 0.929% 0.497% 1.806% I know how to do this using two group proportions: proc power;   TwoSampleFreq   Test=Fisher   Dist= Exact_Cond   Method=Walters   Alpha = 0.05   Sides = 2   GroupProportions = p1  p2   Power = 0.8   NTotal = .   ;run; But How would I modify this program so as one to use just one group in order to generate control and test samples. Any assistance is greatly appreciated! ... View more

Hi all-- I work in direct marketing analytics and I have been using a free app called "Plan-alyser"  to determine if the required sample sizes  needed to ensure a pre-specified difference between two test response rates can be considered significant.  Going forward I would like to use SAS to determine this. Plan-alyser asks the user to input the required information: 1. Estimated response rate for the control panel. 2. Estimated response rate for the test panel 3. The Condidence level How would I replicate this in SAS so I get an output which would determine a value for: 1. The control and test panel sample sizes required for the conditions listed above. 2. The percentage point difference in response  that is considered significant Is there a "Proc" or something else in SAS that will give me this desired output? any assistance is appreciated. Thanks!! ... View more

Hi-- I'm trying use the Proc SQL Index() function to recode some variables into new variables. My program below does not seem to be working correctly -   each line for the case statement is overwriting the value of a previous assignment. Does anyone see what the error is?  Any assistance is appreciated.  Thanks. Proc SQL; Create Table b.DFAimpr2  as Select *, /*** Assign Default ***/ case when AdType='Default' then 1 else 0 end as Default, /*** Assign Tactic ***/ case when index(Campaign, 'C_AWA') gt 0 then 'Awareness' when (index(Campaign, 'C_ACQ')  gt 0 and index(Placement, 'REMARKETING') gt 0) then 'Acquisition: Remarketing'    when (index(Campaign, 'C_ACQ')  gt 0 and index(Placement, 'FTV') gt 0) then 'Acquisition: FTV' when (index(Campaign, 'C_ACQ')  gt 0 and index(Placement, 'iONT') gt 0) then 'Acquisition: iONT' when index(Campaign, 'C_ACQ')  gt 0 then 'Acquisition' else ' ' end as Tactic, /*** Assign Region ***/ Case When index(AdName ,'NAT xNY, xDC, xBaltimore, xNorfolk, xRichmond') gt 0 then 'National: Not NY Not Potomac' When index(AdName ,'NAT xDC, xBaltimore, xNorfolk, xRichmond, xSalisbury') gt 0 then 'National: Not Potomac' When index(AdName ,'NAT xNY') gt 0 then 'National: Not NY' When index(AdName ,'NAT xBOS') gt 0 then 'National: Not Boston' When index(AdName ,'excl BOS') gt 0 then 'National: Not Boston' When index(AdName ,'NAT xPS') gt 0 then 'National: Not PS' When index(AdName ,'NAT xPS&NY') gt 0 then 'National: Not PS Not NY' When index(AdName ,'NY') and not(AdName in ('xNY')) gt 0 then 'New York' When index(AdName ,'DC, Baltimore, Norfolk, Richmond') gt 0 then 'Potomac' When index(AdName ,'CA, FL, NJ, NY DMA') gt 0 then 'CA, FL, NJ, NY DMA' When index(AdName ,'RI, MI, NY, PA, DE, VA, DC, MD') gt 0 then 'RI, MI, NY, PA, DE, VA, DC, MD' When index(AdName ,'TX') gt 0 then 'TX' When index(AdName ,'Albany') gt 0 then 'Albany' When index(AdName ,'Baltimore') gt 0 then 'Baltimore' When index(AdName ,'BOS') gt 0 then 'Boston' When index(AdName ,'Boston') gt 0 then 'Boston' When index(AdName ,'Buffalo') gt 0 then 'Buffalo' When index(AdName ,'Dallas') gt 0 then 'Dallas' When index(AdName ,'DC') gt 0 then 'Washington DC' When index(AdName ,'Harrisburg') gt 0 then 'Harrisburg' When index(AdName ,'LA') gt 0 then 'Los Angeles' When index(AdName ,'Norfolk') gt 0 then 'Norfolk' else 'National' end as Region; quit; ... View more