Architecting, installing and maintaining your SAS environment

Cannot import Excel/Access in SAS9.3

Reply
New Contributor
Posts: 3

Cannot import Excel/Access in SAS9.3

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.

SAS Employee
Posts: 7

Re: Cannot import Excel/Access in SAS9.3

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

Trusted Advisor
Posts: 2,113

Re: Cannot import Excel/Access in SAS9.3

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

New Contributor
Posts: 3

Re: Cannot import Excel/Access in SAS9.3

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

Ask a Question
Discussion stats
  • 3 replies
  • 2251 views
  • 1 like
  • 3 in conversation