BookmarkSubscribeRSS Feed
tulip
Calcite | Level 5
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
3 REPLIES 3
Bill
Quartz | Level 8
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;
tulip
Calcite | Level 5
Hi, Bill:

Thank you so much for the prompt reply.

Let me try it and keep it posted.

Best, Tulip
tulip
Calcite | Level 5
Hi, Bill:

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

Regards, Tulip

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 3 replies
  • 784 views
  • 0 likes
  • 2 in conversation