- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 09-14-2009 12:58 PM
(8253 views)
I will to open the access(mdb) file. Its name is prescription.mdb and is stored in the "Z" drive. I want to use proc import. I am getting a message saying "FILE= or TABLE= is required and must be specified". Please can someone help me.
PROC IMPORT datafile="Z:\prescription.mdb"
out=prescription
dbms=ACCESS
replace;
run;
proc print;run;
PROC IMPORT datafile="Z:\prescription.mdb"
out=prescription
dbms=ACCESS
replace;
run;
proc print;run;
5 REPLIES 5
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
From the SAS support http://support.sas.com/ website and the discussion on PROC IMPORT.
Scott Barry
SBBWorks, Inc.
SAS/Access - PROC IMPORT Statement
http://support.sas.com/documentation/cdl/en/acpcref/61891/HTML/default/a003102095.htm
Scott Barry
SBBWorks, Inc.
SAS/Access - PROC IMPORT Statement
http://support.sas.com/documentation/cdl/en/acpcref/61891/HTML/default/a003102095.htm
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I have tried, but still i can't solve the problem. Please, can you have a look at me data steps and kindly advise me on that. What is the mistake on my program?
PROC IMPORT datafile="Z:\prescription.mdb"
out=mymdb
dbms=ACCESS
replace;
run;
PROC IMPORT datafile="Z:\prescription.mdb"
out=mymdb
dbms=ACCESS
replace;
run;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
After reading the DOC, what part of the SAS error message does not make sense? There are required parameters that are not specified, so the error occurs.
Also, you may want to explore using the SAS LIBNAME ACCESS ....; statement approach - see link to SAS-hosted DOC below:
http://support.sas.com/documentation/cdl/en/acpcref/61891/HTML/default/a002107496.htm
Scott Barry
SBBWorks, Inc.
Also, you may want to explore using the SAS LIBNAME
http://support.sas.com/documentation/cdl/en/acpcref/61891/HTML/default/a002107496.htm
Scott Barry
SBBWorks, Inc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Your syntax is more appropriate to a file than a database. You need the TABLE= and other parameters. See
http://support.sas.com/documentation/cdl/en/acpcref/61891/HTML/default/a003103770.htm
for 9.2 specifics on Access DBs.
http://support.sas.com/documentation/cdl/en/acpcref/61891/HTML/default/a003103770.htm
for 9.2 specifics on Access DBs.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
code that works that may give you some direction ...
PROC IMPORT OUT= WORK.NewOrdFaults
DATATABLE= "NewOrderFaults"
DBMS=ACCESS REPLACE;
DATABASE="\\Moftp\MainFrameFtp\ESADOWN\NewOrderFaults.MDB";
SCANMEMO=YES;
USEDATE=YES;
SCANTIME=NO;
RUN;
PROC IMPORT OUT= WORK.NewOrdFaults
DATATABLE= "NewOrderFaults"
DBMS=ACCESS REPLACE;
DATABASE="\\Moftp\MainFrameFtp\ESADOWN\NewOrderFaults.MDB";
SCANMEMO=YES;
USEDATE=YES;
SCANTIME=NO;
RUN;