topic Re: Importing Access file in SAS Programming

Importing Access file

Shyamkumar — Wed, 07 Aug 2019 17:31:35 GMT

Hi All,

Client given Access file to import in the SAS,
I unable to import the data. Kindly help out me, as it is new to me.

Re: Importing Access file

ballardw — Wed, 07 Aug 2019 17:58:57 GMT

What code have you tried so far?

"unable to import the data" is awful vague.

Are there errors in the log?: Post the code and log in a code box opened with the {i} to maintain formatting of error messages.

No output? Post any log in a code box.

Unexpected output? Provide input data in the form of data step code pasted into a code box, the actual results and the expected results. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

Re: Importing Access file

Shmuel — Wed, 07 Aug 2019 18:03:58 GMT

Searching google for: sas support how to import access database example

listed a great list of result. One of them in this link.

Re: Importing Access file

Ksharp — Thu, 08 Aug 2019 11:56:53 GMT

If you has old access file .try libname statement: libname x 'c:\temp\xxx.mdb'; libname x access 'c:\temp\xxx.mdb'; If you have 2007 version access . try proc import: proc import database='c:\temp\xxxx.acce' datatable='yyyy' out=have dbms=access replace; run;

Re: Importing Access file

Ksharp — Thu, 08 Aug 2019 11:57:16 GMT