BookmarkSubscribeRSS Feed
lisahoward
Calcite | Level 5

Hello,

I am trying to keep all dates in a table that occur between -365 to -30 days prior to Index date. Any dates occurring within 30 days of the Index are not required. I know this is probably quite straightforward code but I can't seem to figure out how to do this.  Any help on the syntax would be appreciated. Many thanks.

1 REPLY 1
Reeza
Super User

Is index date a fixed date or a column in a dat set?

Assuming fixed date and variables that are SAS dates something like the following:

where (fixed_date - date) between 30 and 365;

You may need to change signs or order of subtraction.

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1232 views
  • 0 likes
  • 2 in conversation