Help using Base SAS procedures

importing records generated prior to present date from access db

Reply
N/A
Posts: 0

importing records generated prior to present date from access db

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?
Super Contributor
Super Contributor
Posts: 3,174

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

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
N/A
Posts: 0

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

Yes, but I'm having trouble calling today's date within the IMPORT procedure.
N/A
Posts: 0

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

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
Ask a Question
Discussion stats
  • 3 replies
  • 105 views
  • 0 likes
  • 2 in conversation