I forgot to include the code I have which produces the first three vars: signup_month, Sign_up_count, Initial_Products_total proc sort data=have; by ID signup_DT; run; proc transpose data=have out=have(drop=_LABEL_); by ID signup_DT; run; data have; set have; if signup_DT=COL1 then Initialprod_flag=1;run; proc sql; create table have as select  distinct count( distinct ACCT_SK) as Sign_up_count , month (signup_DT) as signup_month, sum (Initialprod) as Initial_Products_total from have group by month (signup_DT) ; quit; ... View more

I do not know what you have done to get the data work.tvtable there. It is looking that table has been created by a binary upload (using eg Windows explorer) or using an other session (utf8/latin1) for the same location. By that you SAS-dataset is not anymore of native type but of foreign type, by this updating in place (modify) is not possible anymore. To correct that go back and create your work.tctable in a native type that is create that using your current sas version and sas encoding. Moving and Accessing SAS(R) 9.4 Files, Second Edition  (CEDA limitations) http://blogs.sas.com/content/sasdummy/2010/05/24/finding-the-foreigners-in-your-sas-environment/ ... View more

In reply to @data_null: "Old school" defines me.  I would guess 80% of the answers I have given here are because I read the f'in manual, and lo and behold, there was the answer... Steve Denham ... View more

I assume that you are only interested in a positive response--a decrement of 15% either isn't possible or isn't important to what you are doing.  If it were, I figure you would have said something along the lines of a "change of 15%" rather than a lift of 15%. Steve Denham ... View more

There seems to be a lot of confusion here.  Why would you want to know if the sample size is significantly different?  I would think that you want to know if the proportions are significantly different, given the specified sample size. Sometimes Wikipedia is your friend.  The definition of statistical power there is in big bold letters--it is the probability that we conclude that the null hypothesis is false given that the null hypothesis is truly false.  Given that, power= in PROC POWER is not the same as entering a confidence interval. Steve Denham ... View more

Yes - they are supposed to default to national. Here is a data example   AdName                                                                                                                                            Region TT | 160x600 | NAT xDC, xBaltimore, xNorfolk, xRichmond, xSalisbury | Email Advertising | 10.6                  National 728x90 | NY | 10.6                                                                                                                                 New York 160x600 | DC, Baltimore, Norfolk, Richmond,| 11.17                            Potomac 160x600 | 11.17 | DC, Baltimore, Norfolk, Richmond                                                                                 Potomac TT | 11.22 | Preroll :30 | Boston                                             Boston TT | 11.777 | Preroll :30 | Norfolk                                           Norfolk 555x757 | 12.17 | NAT xBOS | 456                                              National: Not Boston                           ... View more

Either TRANWRD or TRANSTR work if you want to replace 'FiOS Presents' with 'FiOS Presents MF'. You want to make sure that the resulting length doesn't exceed the current length of the variable. When I have a problem like this I generally create a new variable that starts with the original value of the problem variable and manipulate that as invariably I create a rule, usually involving a short string such as your |AK, that creates a problem when it replaces unforethought occurences. ... View more

ODS POWERPOINT is available starting in 9.4. A typical workaround is to copy-and-paste your output from another destination to a PowerPoint slide. ... View more

Perhaps even: points_possible = n(of S:); ... View more