DATA Step, Macro, Functions and more

Need help converting date and "between" statement

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

Need help converting date and "between" statement

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.


Accepted Solutions
Solution
‎07-18-2014 11:37 AM
Super User
Posts: 17,868

Re: Need help converting date and "between" statement


All Replies
Solution
‎07-18-2014 11:37 AM
Super User
Posts: 17,868

Re: Need help converting date and "between" statement

Occasional Contributor
Posts: 5

Re: Need help converting date and "between" statement

Thank you, that worked!!

Super User
Super User
Posts: 6,502

Re: Need help converting date and "between" statement

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 170 views
  • 3 likes
  • 3 in conversation