BookmarkSubscribeRSS Feed
deleted_user
Not applicable
All,

I am rookie SAS EG user and cannot figure out how to set a query filter for all rows containing today's date. The field data is datetime, any suggestions would be very appreciated.

MC
2 REPLIES 2
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
The sample below has some discussion regarding variable types - you will need to use DATEPART() and either the TODAY() function or in some instances the constant "&SYSDATE9"D may be preferred.

Scott Barry
SBBWorks, Inc.

Sample 35315: Converting Variable Types in SAS® Enterprise Guide
http://support.sas.com/kb/35/315.html
deleted_user
Not applicable
Many thanks DATEPART() worked like a charm. I was able to create an indicator based on that logic. Your assistance is much appreciated.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 2 replies
  • 5848 views
  • 1 like
  • 2 in conversation