topic Re: Importing a .xlsx file into SAS in SAS Programming

Importing a .xlsx file into SAS

Prateek1 — Mon, 13 Jun 2016 11:57:17 GMT

hi,

i am getting an error while importing a excel file into sas.i am using portable version sas .

this is my code:

proc import datafile="C:\Analytixlabs1\5 - Data Exploration (SAS Module 2)\Grocery_coupons.xls"
out=Grocery_coupons dbms=Excel
Replace;
Sheet="Data";
getnames=yes;
datarow=2;
run;

i am getting an error: Statement is not valid or it is used out of proper order.????????

please help

Re: Importing a .xlsx file into SAS

RW9 — Mon, 13 Jun 2016 12:16:09 GMT

Hi,

Please clarify what software you are using, there is no such thing as portable SAS. Also, post your log including the statements before the problem area.

Re: Importing a .xlsx file into SAS

howarder — Mon, 13 Jun 2016 12:28:42 GMT

One thing to try is to use the right extension:

proc import datafile="C:\Analytixlabs1\5 - Data Exploration (SAS Module 2)\Grocery_coupons.xlsx"

Re: Importing a .xlsx file into SAS

Prateek1 — Mon, 13 Jun 2016 12:39:24 GMT

Hi,

i am using SAS system 9.0 portable version.

what should i do ??

is there any other way to import excel file into sas?

Re: Importing a .xlsx file into SAS

RW9 — Mon, 13 Jun 2016 13:03:37 GMT

You haven't answered either of my questions. There is no such thing as portable SAS, what are you using, how is is setup? Are you using University Edition, or Enterprise Guide etc. You haven't posted the log of what is happening before that statement either.

Re: Importing a .xlsx file into SAS

howarder — Mon, 13 Jun 2016 13:07:22 GMT

I would try changing the file to a .csv instead of a .xlsx file since SAS may have problems reading in an Excel file with any verison prior to SAS 9.2.

Re: Importing a .xlsx file into SAS

Kurt_Bremser — Mon, 13 Jun 2016 13:09:53 GMT

Define "portable".

And SAS 9.0 is way beyond old. The oldest SAS version reasonably used is 9.2.

AND POST YOUR LOG!!!!!

Re: Importing a .xlsx file into SAS

Ksharp — Tue, 14 Jun 2016 02:44:31 GMT

"datarow=2;" is not supported by engine Excel, remove it .