BookmarkSubscribeRSS Feed
Denis972
Calcite | Level 5

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

 

 

3 REPLIES 3
andreas_lds
Jade | Level 19

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.

Denis972
Calcite | Level 5

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

Denis972
Calcite | Level 5

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 🙂

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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