SAS Procedures

Help using Base SAS procedures
BookmarkSubscribeRSS Feed
Statsconsultancy
Fluorite | Level 6
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;
5 REPLIES 5
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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
Statsconsultancy
Fluorite | Level 6
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;
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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.
Doc_Duke
Rhodochrosite | Level 12
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.
Bill
Quartz | Level 8
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;

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 8254 views
  • 1 like
  • 4 in conversation