Hi All,   I am trying to automate some code with the use of date macros but encountered some Inavlid date/time/datetime constant errors.   I have assigned the macros as below   %let StartDate ='31oct2015'd; %put StartDate= &StartDate; %let Enddate = intnx('month', today(),-1, 'end'); %put EndDate= &EndDate; Where CreatedOn<='&Enddate'd and CreatedOn>='&StartDate'd  and using them in the context above.     Any help will be greatly appreciated !   Thanks   Adnan               ... View more

Hi, I am trying to build a 3 way Venn diagram visualising the data below.   Id                       min     max  avg Good                 12      49    25 Bad                   12      41    30 Intermediate      23     46    49     I have sourced a macro via Google and does not seem provide a solution to my issue.   Macro Call %macro venn( data =summary_exp6 ,venn_diagram = 3 ,cutoff = < 0.3 ,Good = Treatment A ,Bad = Treatment B ,Intermediate  = Treatment C ,out_location = H:\SAS Projects ,outputfilename = Venn diagram );  The macro above (according to my limited SAS knowledge) will not alone create the output which I require.  I would be gratetful of any help resolving this issue.   Thanks ! ... View more