Dear all,
I have a variables A and B in date formats (mmyyn6.). Now in a datastep I have a code that looks like this:
I know this is not correct but can any one help
data want;
set have
if A >= 'Nov2000'd and B<= 'Dec2010'd;
run;
Dates must be represented in the following form:
'01JAN2022'd
and not any other form (except that lower case letters are allowed). So, inside the quotes, the day of the month (2 digits) comes first, followed by three letter month, followed by four digit year.
So you may want this:
data want;
set have
if a >= '01Nov2000'd and b <= '31Dec2010'd;
run;
See Date, Time, and Datetime Constants for the correct format of date constants (literals).
Dates must be represented in the following form:
'01JAN2022'd
and not any other form (except that lower case letters are allowed). So, inside the quotes, the day of the month (2 digits) comes first, followed by three letter month, followed by four digit year.
So you may want this:
data want;
set have
if a >= '01Nov2000'd and b <= '31Dec2010'd;
run;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.