SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

How to export MS acess to SAS data

Reply
Occasional Contributor
Posts: 18

How to export MS acess to SAS data

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
Super Contributor
Posts: 291

Re: How to export MS acess to SAS data

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;
Occasional Contributor
Posts: 18

Re: How to export MS acess to SAS data

Hi, Bill:

Thank you so much for the prompt reply.

Let me try it and keep it posted.

Best, Tulip
Occasional Contributor
Posts: 18

Re: How to export MS acess to SAS data

Hi, Bill:

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

Regards, Tulip
Ask a Question
Discussion stats
  • 3 replies
  • 211 views
  • 0 likes
  • 2 in conversation