topic How to export MS acess to SAS data in Microsoft Integration with SAS

How to export MS acess to SAS data

tulip — Wed, 23 Sep 2009 17:27:50 GMT

Hi, guys:

I run into a problem. I have data in MS acess and would like to convert it to SAS.

First, I tried to use sas import. I requested user name, password, workgroup DB and workgroup DB password. Regarding workgroup file and corresponding password, I have no clue.

Second, I tried to use acess export function. However, I could not find it. Please advise. Your help is greatly appreciated.

Tulip

Re: How to export MS acess to SAS data

Bill — Wed, 23 Sep 2009 18:30:22 GMT

tulip;

Import code below is what I use to import. Below that is the code I use to export the same file once I've run it through some SAS steps.

PROC IMPORT OUT= WORK.NewOrdFaults
DATATABLE= "NewOrderFaults"
DBMS=ACCESS REPLACE;
DATABASE="\\Moftp\MainFrameFtp\ESADOWN\NewOrderFaults.MDB";
SCANMEMO=YES;
USEDATE=YES;
SCANTIME=NO;
RUN;

PROC EXPORT DATA= WORK.UpDater
OUTTABLE= "NewOrderFaults"
DBMS=ACCESS REPLACE;
DATABASE="\\MOFtp\MainFrameFtp\EsaDown\NewOrderFaults.MDB";
RUN;

Re: How to export MS acess to SAS data

tulip — Wed, 23 Sep 2009 21:00:35 GMT

Hi, Bill:

Thank you so much for the prompt reply.

Let me try it and keep it posted.

Best, Tulip

Re: How to export MS acess to SAS data

tulip — Wed, 23 Sep 2009 21:21:47 GMT

Hi, Bill:

I tried it and it worked so well. Again, thanks lot.

Regards, Tulip