Hey everyone, I have been trying to search thet net, but to no avail.  I am putting together a new insights deck, and for part of it I need to count unique customers who have done a certain activity within the past 12 months, by month My final output will look something like: Month               # of Customers (who have done this activity from 12 months back) Jan-11               10 (i.e. 10 distinct customers have done this actvitiy at least once between 2/1/10 - 1/31/11) Feb-11               12 Mar-11               15 Apr-11               14 May-11               18 etc... So if someone had done the activity in, say, January 2010 and April 2010, he would show up in the LTM for January and for March, but drop off for April. I can't just group by month and add, because then I will pick up duplicate customers. Please help!  Thank you so much! ... View more

Hello, I have a data set with 14 different groupings of test/control records, and I need to run t-tests on all.  So I have one variable titled, "Test_ID" and the values run A1, A2, A3... A14 (test) and Z1, Z2 .... Z14 (control).  I want to test for the difference in the variable, "Revenue."  Is there a simple statement I am overlooking on the white papers which will let me do this, or do I just need to write a macro do loop and let that run through? Thanks! --Russell          ... View more

Hey Everyone, I can't seem to find this... I am setting up some macros to automate reports to get on to more interesting projects... I am using the INTX function for date ranges. i.e. beginning and end of a month (in a data null step) call symputx('BEGDATE' , "'" || put(intnx('month',today(),-13,'BEGIN'),yymmdd10.) || "'"); call symputx('ENDDATE' , "'" || put(intnx('month',today(),-1,'END'),yymmdd10.) || "'"); Output '2010-10-01' or '2011-09-30' This works great.  However, I have another date value that is stored as YYYYMM (i.e. 201010 or 201109 from above examples). So I wrote the following: call symputx('prev_beg' , "'" || put(intnx('year' ,today(),-1),YEAR.)|| put(intnx('month',today(),-1,'END'),MONTH.) || "'"); call symputx('prev_end' , "'" || put(intnx('year' ,today(),0),YEAR.) || put(intnx('month',today(),-2,'END'),MONTH.) || "'"); However, if the month is Jan - Sep (1-9), it doesn't give a preceeding zero.  Is there any known format to include this?  Or do I just need to use some conditional formatting? Google doesn't seem to have the answer... so if you ever have had to do this I appreciate any input! Thanks! --Russell                    ... View more

Hey everyone, I have a quick question.  I have the following code to email me an ODS output, but for some reason it emails me two times every time it runs.  Any ideas? Thanks!               FILENAME mail EMAIL    TO= '<email>'    FROM='<me>'          SUBJECT="Promo Report"    ATTACH='/directory/Promo_Enroll.xls'; DATA _NULL_;   FILE mail; PUT 'Good Morning,'; PUT ' '; PUT 'Attached you will find the updated Promo Enrollees and Qualifiers by market.'; PUT 'Feel free to contact me with any questions.'; PUT ' ';   PUT "!EM_SEND!"; RUN; ... View more