topic I failed Import procedure to Excel in New SAS User

I failed Import procedure to Excel

kokodenden52 — Mon, 12 Nov 2018 14:57:24 GMT

I tried the program below on SAS University Edition.

However it failed.

proc import out=test
datafile="C:\Users\Owner\Desktop\folder\test.xlsx"
replace;

sheet = "sheet1";
getnames = yes;
run;

The error message says

"Statement or option "Getnames" is invalid to EXCELCS IMPORT."

Which parts is mistaken?

Please teach me.

Re: I failed Import procedure to Excel

Kurt_Bremser — Mon, 12 Nov 2018 15:12:45 GMT

Put your file in the shared folder, and use

/folders/myfolders/.......xlsx

as the path in University Edition. Also use

dbms=xlsx

in your proc import statement.

GETNAMES will not work for Excel files. From the documentation of the GETNAMES statement:

Interaction:

The GETNAMES statement is valid only for delimited files.

Re: I failed Import procedure to Excel

RW9 — Mon, 12 Nov 2018 15:14:21 GMT

Please follow the video help, which goes over importing data.

https://video.sas.com/category/videos/how-to-tutorials

First off you cannot refer to the file on your local machine, UE is installed to a virtual image, so you need to refer to a shared folder - setup is also part of the training vids.

Next up, you will want to set the dbms option:

proc import ... dbms=excel..