topic Re: Importing MS Access 07 to SAS data set in ODS and Base Reporting

Importing MS Access 07 to SAS data set

deleted_user — Tue, 25 Jan 2011 00:02:39 GMT

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-Office-2007-files.html

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

Re: Importing MS Access 07 to SAS data set

twocanbazza — Tue, 25 Jan 2011 00:16:17 GMT

Might be a good Idea that you supply the code and Log so someone can help you...

Re: Importing MS Access 07 to SAS data set

deleted_user — Tue, 25 Jan 2011 00:59:22 GMT

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

Re: Importing MS Access 07 to SAS data set

Ksharp — Tue, 25 Jan 2011 04:57:46 GMT

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

Ksharp

Re: Importing MS Access 07 to SAS data set

deleted_user — Sat, 29 Jan 2011 00:13:21 GMT

umm still cant get it to work. Using enterprise guide 4.1 Message was edited by: solarity

Re: Importing MS Access 07 to SAS data set

Cynthia_sas — Sat, 29 Jan 2011 22:55:28 GMT

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

Re: Importing MS Access 07 to SAS data set

Ksharp — Mon, 21 Feb 2011 06:10:35 GMT

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