Hello,
My over-research for something that I believe should be simple has caused me to be terribly confused on how to use today() function in a where statement.
A column in my data is in the date format DATETIME22.3. I simply want to create subset that excludes any observations with a date greater than today.
All I want is to be able to reference today as a macro &today. as DATETIME22.3.
Thanks,
Autumn
/*this gives me 0 observations because today() appears to be a different format than activity_date_update*/
data latest_activity1;
set latest_activity;
if activity_date_update > today() then delete;
run;
/*this macros I found on my research appear to be used on for character macros*/
data _null_;
call symputx('dt',put(date(),yymmddn8.);
run;
data latest_activity1;
set latest_activity;
if activity_date_update > &dt. then delete;
run;
Hello,
SInce your column is in datetime format you can not compare it directly to a date.
Use the datepart function to extract the date from datetime.
where datepart(activity_date_update)>today();
Hello,
SInce your column is in datetime format you can not compare it directly to a date.
Use the datepart function to extract the date from datetime.
where datepart(activity_date_update)>today();
Thank you very much, my google searches let me down a very different path.
Pet peeve mixing up date and datetime values.
@akovach wrote:
A column in my data is in the date format DATETIME22.3. I simply want to create subset that excludes any observations with a date greater than today.
In SAS dates and datetimes are measured in different units: date uses days and datetime uses seconds. Proper use of the values involved will help in the long term.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.