topic Using the DATE() or TODAY() Function When Filtering in SAS EG 4.1 in SAS Enterprise Guide

Using the DATE() or TODAY() Function When Filtering in SAS EG 4.1

deleted_user — Sat, 22 Aug 2009 17:57:57 GMT

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

Re: Using the DATE() or TODAY() Function When Filtering in SAS EG 4.1

sbb — Sat, 22 Aug 2009 19:21:12 GMT

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

Re: Using the DATE() or TODAY() Function When Filtering in SAS EG 4.1

deleted_user — Sat, 22 Aug 2009 21:08:27 GMT

Many thanks DATEPART() worked like a charm. I was able to create an indicator based on that logic. Your assistance is much appreciated.