importing records generated prior to present date from access db

[deleted_user]

I need to import a table from an access database and I only want the records that were entered prior to the date that I run the import. Data are continuously entered into the database and I want to avoid importing incomplete records. I have a variable "entrydate", can I use a WHERE statement with the TODAY() function in PROC IMPORT? Or do I just need to filter those data from the sas dataset created by the import?

[sbb]

Have a look at the SAS DOC on PROC IMPORT - consider the OUT= and the "data-set-options" specification for the WHERE= clause).

Scott Barry
SBBWorks, Inc.

PROC IMPORT Statement
http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a000308090.htm

[deleted_user]

Yes, but I'm having trouble calling today's date within the IMPORT procedure.

[deleted_user]

The problem was due to different formats and inclusion of the time. Here's the solution:

where=(datepart(entrydate) ne datepart(datetime())) Message was edited by: DDC