topic Need help converting date and "between" statement in SAS Programming

Need help converting date and "between" statement

Breezy — Fri, 18 Jul 2014 15:29:28 GMT

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.

Re: Need help converting date and "between" statement

Reeza — Fri, 18 Jul 2014 15:37:04 GMT

Use the monyy7. format.

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

Re: Need help converting date and "between" statement

Breezy — Fri, 18 Jul 2014 15:45:30 GMT

Thank you, that worked!!

Re: Need help converting date and "between" statement

Tom — Fri, 18 Jul 2014 15:47:48 GMT

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.