Desktop productivity for business analysts and programmers

Using SAS Dates

Not applicable
Posts: 1

Using SAS Dates

Hi, does anyone know how to reference a time period by adding and subtracting months. For example if the variable is &startdate how would I be able to pull all records 6 months after the date?  6 months before the date?  Thanks!

Super User
Posts: 8,214

Using SAS Dates

Posted in reply to Jillian003

You can use the intnx function.  e.g., to get all dates before and after &startdate. you could use:

if intnx('month',&startdate.,-6,'same') <=&startdate.<= intnx('month',&startdate.,6,'same');

Ask a Question
Discussion stats
  • 1 reply
  • 1 like
  • 2 in conversation