topic Import d'une base access sous SAS /import access base in SAS in SAS Programming

Import d'une base access sous SAS /import access base in SAS

Denis972 — Tue, 13 Aug 2019 10:22:56 GMT

This message is in french and in english.

FR: Bonjour,

Je viens vers vous par rapport à un problème qui me pénalise fortement: Je ne parviens pas à importer une base access sous sas!

Mon code est le suivant:

PROC EXPORT DATA=Ma_table
OUTTABLE=table_sortie DBMS=ACCESS REPLACE;
DATABASE="chemin\nom_table_access.accdb";
RUN;

Après exécution je vois le message d'erreur suivant:

ERROR: Le fichier _IMEX_.nom_table_access.DATA n'existe pas.
ERROR: Import unsuccessful. See SAS Log for details.

J'ai essayé de remplacer dans le code l'option ACCESS par ACCESCS mais j'ai un autre message d'erreur qui s'affiche:
ERROR: Failed to connect to the Server: .

Je travail avec la version 9.4 de sas et sur la version de 2010 d'access.

Pouvez-vous m'aider svp? Là je ne vois vraiment pas ce que je dois tenter....

Bien cordialement,
Denis

ENG:Hello,

I come to you in relation to a problem that strongly penalizes me: I don't manage to import a ACCESS base in sas!

My code is that following:

PROC EXPORT DATA=My_table
OUTTABLE=table_out DBMS=ACCESS REPLACE;
DATABASE="path\tablename_access.accdb";
RUN;

when I execute it this message appear:

ERROR: the file _IMEX_.tablename_access.DATA don't exist.
ERROR: Import unsuccessful. See SAS Log for details.

I have tried to replace in the code the option ACCESS by ACCESCS but a other message appear:
ERROR: Failed to connect to the Server: .

I work on the version 9.4 of SAS and on the version 2010 of ACCESS.

Can you help me please? I really don't see what I can try....

Sincerely,
Denis

Re: Import d'une base access sous SAS /import access base in SAS

andreas_lds — Tue, 13 Aug 2019 12:03:46 GMT

You are talking about importing in the title, but you are using proc export. Do you want to read and Access-file or create one? For reading, use proc import.

Re: Import d'une base access sous SAS /import access base in SAS

Denis972 — Tue, 13 Aug 2019 12:32:39 GMT

Sorry, I made a mistake. The code for the import is

PROC IMPORT TABLE=My_table OUT=out_table DBMS=ACCESS REPLACE;
DATABASE=path\accesstable.accdb;
RUN;

It's really for the import that I have the problem

Re: Import d'une base access sous SAS /import access base in SAS

Denis972 — Mon, 19 Aug 2019 08:20:24 GMT

Hello,

I solved my problem, it was the compatibility of the versions.

My SAS was 64 bit and my ACCESS was 32 bit.

After installing the right version of ACCESS, I was able to import.

Maybe it will help sombody else.

Have a nice day 🙂