topic Import spreadsheet (xls) data into SAS dataset in SAS Procedures

Import spreadsheet (xls) data into SAS dataset

deleted_user — Fri, 06 Nov 2009 11:21:07 GMT

Hi,

I am working on SAS 8.02 (both on UNIX and Windows environment).
I have observed that Proc Import of spreadsheet (xls) works fine on windows(base sas) but it doesnt work on Unix environment.

proc import
datafile = "abc.xls"
out = PERM.ABC dbms=XLS replace;
getnames=yes;
run;

SAS/ACCESS is installed both on Windows as well as UNIX.

Is it correct observation? If yes, do we have any other alternative to import the xls data into the SAS dataset in UNIX(except converting the xls to csv) in SAS 8.02?.

Re: Import spreadsheet (xls) data into SAS dataset

sbb — Fri, 06 Nov 2009 13:06:18 GMT

"..but it doesnt work on Unix environment."

What is the exact symptom or error/warning messages you receive when attempting the process? This is important information.

Also, did you have an opportunity to search the SAS support http://support.sas.com/ website to investigate your problem/symptom?

Scott Barry
SBBWorks, Inc.

Re: Import spreadsheet (xls) data into SAS dataset

sbb — Fri, 06 Nov 2009 13:10:05 GMT

From the SAS support website, here is a SUGI conference paper that may shed some light on your situation.

You also need to seriously consider moving up to a fully-supported SAS version.

Scott Barry
SBBWorks, Inc.

How to Access PC File Data Objects Directly from UNIX
Howard Plemmons, SAS® Institute Inc., Cary, NC
http://www2.sas.com/proceedings/sugi28/156-28.pdf

Re: Import spreadsheet (xls) data into SAS dataset

deleted_user — Fri, 06 Nov 2009 13:22:40 GMT

You are correct Scott, looking at the SAS documentation you have sent, we would need to upgrade the SAS version as soon as possible.

But for now if there any other approach that can help me getting the xls data into the SAS dataset in UNIX.

Scott, can you tell me how do to exactly search in support.sas.com. Is there any specific format for searching. I mostly get vague result in searching.

Re: Import spreadsheet (xls) data into SAS dataset

sbb — Fri, 06 Nov 2009 15:39:20 GMT

My preference is using Google advanced search - include the site:sas.com parameter to limit the search just to the SAS.COM domain/website. With your search arguments, you can use words, phrases, with "required" and/or "not" conditions. Check out the advanced search hyperlink on the Google.com home page for details.

Scott Barry
SBBWorks, Inc.

Re: Import spreadsheet (xls) data into SAS dataset

Doc_Duke — Fri, 06 Nov 2009 17:25:41 GMT

export the Excel file to CSV and import with the macros in this article

http://www.sas.com/offices/europe/uk/newsletter/feature/issue28/tips-enterprise-csv.html