The SAS Output Delivery System and reporting techniques

Importing MS Access 07 to SAS data set

Reply
N/A
Posts: 0

Importing MS Access 07 to SAS data set

Been trying to do this on enterprise guide using code but its not working.

I tried the steps from here:
http://blogs.sas.com/sasdummy/index.php?/archives/24-Using-SAS-Enterprise-Guide-to-read-Microsoft-Of...

And this allowed me to open up the access file in SAS format (under work), however I still cant save this file down so I can use it for calculations and other functions.

Just wondering if there are any solutions to do this on code? (The code gives me a error message that my libname is invalid, when it clearly isnt. Just using the proc import function dmbs=access etc.)

Cheers
Super Contributor
Posts: 356

Re: Importing MS Access 07 to SAS data set

Posted in reply to deleted_user
Might be a good Idea that you supply the code and Log so someone can help you...
N/A
Posts: 0

Re: Importing MS Access 07 to SAS data set

Posted in reply to twocanbazza
PROC IMPORT DATAFILE="XXX"
OUT=test DBMS=access REPLACE;
GETNAMES=YES;
DATAROW=2;
RUN;


NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to
WORK.PARMS.PARMS.SLIST.
Unable to sample external file, no data in first 5 records.
NOTE: Import Cancelled.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 1.03 seconds
user cpu time 0.04 seconds
system cpu time 0.09 seconds
Memory
Super User
Posts: 10,023

Re: Importing MS Access 07 to SAS data set

Posted in reply to deleted_user
Hi.
Your proc import syntax is wrong for the Access file .
For the detail about it,search it in support.sas.com.



Ksharp
N/A
Posts: 0

Re: Importing MS Access 07 to SAS data set

umm still cant get it to work. Using enterprise guide 4.1 Message was edited by: solarity
SAS Super FREQ
Posts: 8,864

Re: Importing MS Access 07 to SAS data set

Posted in reply to deleted_user
Hi:
If you followed the steps in the blog post and things work; but then you try the generated code and things don't work, you might want to open a track with Tech Support. It was my understanding that the blog post recommended using SAS/Access to ODBC to get to a Microsoft Access database file. But, does the EG generated code, actually reference DBMS=ACCESS or DBMS=ACCESSCS??? Just like this note shows the use of ExcelCS, you may have to use ACCESSCS instead of the "plain" Access driver???
http://support.sas.com/kb/37/479.html

That would actually be something you could find out from Tech Support -- as your operating system version, your Office version -and- your various servers might come into play in addition to your EG version.

You might also want to post this question in the Enterprise Guide forum, where more EG folks and the author of that original blog all hang out.

cynthia
Super User
Posts: 10,023

Re: Importing MS Access 07 to SAS data set

Posted in reply to deleted_user
Hi.
Sorry .I did not notice you are using access07, I think proc import can not support Office2007,you need libname xxx odbc '...' just as Cynthia mentioned to import data set.


Ksharp
Ask a Question
Discussion stats
  • 6 replies
  • 152 views
  • 0 likes
  • 4 in conversation