07-18-2014 11:29 AM
Could use your expertise in something, trying to format a date to be able to pull together a new column of fiscal months.
So the data set has AccountDate which looks like: 01APR2014 (has 15 years of dates).
I want to write my code so I roll up all dates into their respective months, so any date that falls between (April 1 and April 30 of 2014 goes into New_Month = April_2014).
The data field is currently DATE9.
Any help would be appreciated.
07-18-2014 11:47 AM
Depending on what you are doing you might just need to apply a format.
proc freq data=mydata ;
tables mydate ;
format mydate monyy7.;
If you do need to make a new variable then perhaps INTNX() is what you want?
You could set the new variable to the first of the month.
newvar = intnx('month',mydate,0) ;
You could then use what ever format you want for the new variable.
Need further help from the community? Please ask a new question.