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
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.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.