topic Re: Cannot import Excel/Access in SAS9.3 in Administration and Deployment

Cannot import Excel/Access in SAS9.3

mk7687mk — Tue, 08 May 2012 04:14:23 GMT

I want to import Excel file into SAS, but could not find Import option for Excel and Access in SAS9.3.It is very strange.

I have tried through Proc Import and Import Wizard, but could see only CSVs or tab delimited file options.Would I need to install something to get that? Please help me out.

Re: Cannot import Excel/Access in SAS9.3

Bago — Tue, 08 May 2012 06:45:59 GMT

Hey,

Sounds like you don't have SAS/Access Interface to PC Files (http://www.sas.com/software/data-management/access/pcfile.html ) licensed. You need this license to import Excel files directly.

Run

proc setinit noalias;

run;

In the log you should see a reference to "SAS/ACCESS Interface to PC Files". If not this means you don't have it licensed.

As a workaround save your Excel files as either tab delimited or csv files. You can import these files using Base sas.

Kind regards,

Bago

Re: Cannot import Excel/Access in SAS9.3

Doc_Duke — Tue, 08 May 2012 14:35:31 GMT

MK,

PROC SETINIT will tell you what you have licensed, not what you have installed. So if it says you have SAS/Access for PC files, talk to your local support folk about getting the additional pieces installed.

Another workaround might be to use Enterprise Guide to read the Excel files. EGuide is part of Base SAS for 9.3 and includes some of it's own routines for reading Excel (right now, I feel like EGuide has more features for reading 'difficult' Excel files than IMPORT does).

Doc Muhlbaier

Duke

Re: Cannot import Excel/Access in SAS9.3

mk7687mk — Sat, 01 Sep 2012 17:46:42 GMT

Thanks for the responses. Yes, we donot have the licence, so I have used EGuide as an alternative