topic Re: importing records generated prior to present date from access db in SAS Procedures

importing records generated prior to present date from access db

deleted_user — Wed, 08 Apr 2009 14:14:28 GMT

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?

Re: importing records generated prior to present date from access db

sbb — Wed, 08 Apr 2009 14:19:53 GMT

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

Re: importing records generated prior to present date from access db

deleted_user — Wed, 08 Apr 2009 14:46:41 GMT

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

Re: importing records generated prior to present date from access db

deleted_user — Wed, 08 Apr 2009 15:34:13 GMT

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