Need help converting date and "between" statement

[Breezy]

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.

[Reeza · Accepted solution]

Use the monyy7. format.

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

[Breezy]

Thank you, that worked!!

[Tom]

Depending on what you are doing you might just need to apply a format.

proc freq data=mydata ;

  tables mydate ;

  format mydate monyy7.;

run;

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.