Help using Base SAS procedures

Import spreadsheet (xls) data into SAS dataset

Reply
N/A
Posts: 0

Import spreadsheet (xls) data into SAS dataset

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?.
Super Contributor
Super Contributor
Posts: 3,174

Re: Import spreadsheet (xls) data into SAS dataset

Posted in reply to deleted_user
"..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.
Super Contributor
Super Contributor
Posts: 3,174

Re: Import spreadsheet (xls) data into SAS dataset

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
N/A
Posts: 0

Re: Import spreadsheet (xls) data into SAS dataset

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.
Super Contributor
Super Contributor
Posts: 3,174

Re: Import spreadsheet (xls) data into SAS dataset

Posted in reply to deleted_user
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.
Trusted Advisor
Posts: 2,116

Re: Import spreadsheet (xls) data into SAS dataset

Posted in reply to deleted_user
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
Ask a Question
Discussion stats
  • 5 replies
  • 114 views
  • 0 likes
  • 3 in conversation