This assumes that the variable is numeric with a datetime format applied. If the date is character this answer does not apply. Use the INTNX() function with a 0 increment and align the date to the end of the month using 'e'. The DATEPART() function converts the datetime variable to a date variable. SAS(R) 9.3 Functions and CALL Routines: Reference data want; set have; date_want=intnx('month', datepart(cons_date), 0, 'e'); format date_want date9.; run;
... View more