08-05-2016 09:39 AM
I try to change the first day of month to latest day of the month. I prepared a sample code as below. Is it possible to round the date variable?
Data Have; Format Date DATE9.; Infile Datalines Missover; Input Date; Datalines; 19510 19602 19693 19783 19875 19967 20058 20148 ; Run;
08-05-2016 09:52 AM
I have just checked it, I need to put "0"
Data Want; Set Have; NewDate=Intnx("Month",Date,0,"End"); Format NewDate Date9.; Run;
Need further help from the community? Please ask a new question.