I'm sure you can get more help with the analysis part but I'm wondering if prepping the data would help. Does this get you anywhere closer to where you want to be? data have; infile cards dsd; informat date mmddyy10.; format date mmddyy10.; input date time_to_default; cards; 10/31/2015,6 ; run; data want; format default_date mmddyy10.; set have; default_date = intnx('month',date,time_to_default,'e'); run;
... View more
