Desktop productivity for business analysts and programmers

Using SAS Dates

Reply
N/A
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!

PROC Star
Posts: 7,432

Using SAS Dates

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
  • 145 views
  • 1 like
  • 2 in conversation