topic Using SAS Dates in SAS Enterprise Guide

Using SAS Dates

Jillian003 — Sat, 25 Feb 2012 17:23:23 GMT

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!

Using SAS Dates

art297 — Sat, 25 Feb 2012 18:33:28 GMT

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');