topic Re: can't get data from Excel file in SAS Programming

can't get data from Excel file

KK_QQ — Mon, 23 Jan 2017 05:12:11 GMT

I am using SAS University Edition. I tried to using below statment to access excel file

libname prod xlsx "/folders/myfolders/SAS/book1.xlsx";

Actually there is no error in log. But I can only see the prod libref is created but there is no way to access the data in the Excel file.

I attach the book1 file, from sheet2 you can see the result from proc contents, there is connection, but can't read data.

SASKiwi — Mon, 23 Jan 2017 06:13:22 GMT

Try PROC IMPORT as described here:

Reeza — Mon, 23 Jan 2017 07:45:56 GMT

How did you try and 'read' the file. Did that generate an error? Include your code and log.

KK_QQ — Tue, 24 Jan 2017 03:59:38 GMT

libname prod xlsx "/folders/myfolders/SAS/book1.xlsx";

Log

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

56 libname prod xlsx "/folders/myfolders/SAS/book1.xlsx";

NOTE: Libref PROD was successfully assigned as follows:

Engine: XLSX

Physical Name: /folders/myfolders/SAS/book1.xlsx

58 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

KK_QQ — Tue, 24 Jan 2017 04:07:51 GMT

Import is working. But I feel it works more like input, create new dataset. Not like libname create a link to file.

KK_QQ — Tue, 24 Jan 2017 04:09:34 GMT

Sorry, I mean infile

Reeza — Tue, 24 Jan 2017 04:32:33 GMT

Did you try accessing the data with a data step? Post that code

KK_QQ — Wed, 25 Jan 2017 04:39:22 GMT

No, I can't. After I use libname, there have libref created, but it empty, there is no data.

Reeza — Wed, 25 Jan 2017 06:08:13 GMT

How do you know it's empty?

Did you try a data step?

Data want;

set libname.'Sheet1$'n;

run;