DATA Step, Macro, Functions and more

How to select data from a specified time period

Accepted Solution Solved
Reply
Contributor ZZB
Contributor
Posts: 40
Accepted Solution

How to select data from a specified time period

Hi all,

I want to select only data from 02/29/2008 to 05/31/2009. The DATE format in my dataset is MMDDYY10.

I failed if using codes like [ if '02/29/2008'<=date<='05/31/2009' ].

Thanks a lot


Accepted Solutions
Solution
‎03-13-2014 02:26 AM
Super User
Posts: 7,766

Re: How to select data from a specified time period

Is "date" a numeric variable formatted with mmddyy10.?

If so, then you need to write the condition like that:

if '29feb2008'd <= date <= '31may2009'd

'ddmmmyyyy'd is a date constant. Similar modifiers are t for time or x for hexadecimal.

If "date" is a string that contains MM/DD/YYYY values, I would recommend to use input(date,mmddyy10.) between the constants.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎03-13-2014 02:26 AM
Super User
Posts: 7,766

Re: How to select data from a specified time period

Is "date" a numeric variable formatted with mmddyy10.?

If so, then you need to write the condition like that:

if '29feb2008'd <= date <= '31may2009'd

'ddmmmyyyy'd is a date constant. Similar modifiers are t for time or x for hexadecimal.

If "date" is a string that contains MM/DD/YYYY values, I would recommend to use input(date,mmddyy10.) between the constants.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
🔒 This topic is solved and locked.

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

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