topic Re: Excel file uploaded in library successfully in New SAS User

Excel file uploaded in library successfully

ws_adan — Sat, 25 Jul 2020 14:39:43 GMT

in message libref EXL was successfully assigned but it is now showing excel sheet in library.

libname ExL xlsx 'C:\Users\Wajeeha Bilal\Desktop\T2_YARD.XLSX';

Re: Excel file uploaded in library successfully

PaigeMiller — Sat, 25 Jul 2020 14:51:32 GMT

What is your question?

Re: Excel file uploaded in library successfully

ws_adan — Sat, 25 Jul 2020 14:57:37 GMT

my question is i could not find excel sheet in library

Re: Excel file uploaded in library successfully

ws_adan — Sat, 25 Jul 2020 16:00:33 GMT

dear can anyone help on this.

how can i see my sheet as dataset in SAS library.

there is no error no warnings in notes also showing successfully assigned.

please let me know what i have to do any other option to make dataset from excel.

Re: Excel file uploaded in library successfully

PaigeMiller — Sat, 25 Jul 2020 16:07:56 GMT

The library name EXL must be used.

To use a particular sheet, let's say its name is SHEET1, the in SAS you must call it EXL.SHEET1.

For example

proc print data=exl.sheet1(obs=10);
run;

Re: Excel file uploaded in library successfully

Kurt_Bremser — Sun, 26 Jul 2020 09:27:09 GMT

Which kind of SAS installation do you use?

University Edition?
Enterprise Guide with a Local server?
Enterprise Guide/SAS Studio with a remote server?

Re: Excel file uploaded in library successfully

Tom — Sun, 26 Jul 2020 15:07:36 GMT

Just because the LIBNAME statement works it does NOT mean that the request XLSX file was actually found.

SAS does not know whether you are trying to access and existing file or create a new file.

Check the name of the file.

Re: Excel file uploaded in library successfully

ws_adan — Mon, 27 Jul 2020 13:17:16 GMT

Dear,

i am new and i installed below version

University Edition?

Re: Excel file uploaded in library successfully

Tom — Mon, 27 Jul 2020 13:25:20 GMT

Looks like your screen shot is from SAS/Studio. So in that left hand panel open the Server Files and Folders view and find the file you want to read. Right click and open the Properties for the file. On that pop-up screen should be the location or path for the file. Copy that and use it in your LIBNAME statement.

Re: Excel file uploaded in library successfully

Kurt_Bremser — Mon, 27 Jul 2020 14:04:14 GMT

University Edition is a "miniaturized" Business Intelligence (BI) server in a virtual machine running on Linux. It does not have access to your Windows disk drive(s), only to the shared folder you set up when you imported the VM into your virtualization software (Virtualbox or VMPlayer). You address the shared folder (if you followed the instructions correctly) as /folders/myfolders from within the VM.

Store your xlsx file in the Windows location of the shared folder, and use the correct Linux path in your SAS code. Keep in mind that Linux (like all UNIX systems) is case sensitive, so spelling is critical.

Re: Excel file uploaded in library successfully

ws_adan — Mon, 27 Jul 2020 14:55:19 GMT

Dear ,

i did in VM as below and i put my excel file in same folder.

now what i have to do to load my excel file in SAS share folder.

Re: Excel file uploaded in library successfully

Tom — Mon, 27 Jul 2020 15:40:18 GMT

In your screen shot the UNIX folder name is on the left and the WINDOWS folder name is on the right.

In your SAS code you need to use the UNIX path for the file. Not the WINDOWS path.

So if your file on WINDOWS is <windows path>\filename then your SAS session will see the file at <unix path>/filename.

In SAS University edition the <unix path> is ALWAYS /folders/myfolders

Re: Excel file uploaded in library successfully

ws_adan — Mon, 27 Jul 2020 16:10:23 GMT

Dear,

i put in code window as below;

libname Yard XLSX 'C:\Windows\SAS\SASUniversityEdition\myfolders\T2_YARD.XLSX';

after that

PROC DATASETS LIBRARY=YARD;

it is not showing excel sheet data could you let me know what is going wrong.

is it due to university edition?

Re: Excel file uploaded in library successfully

Kurt_Bremser — Mon, 27 Jul 2020 16:12:57 GMT

You put your file (using Windows Explorer) in

C:\Windows\SAS\SASUniversityEdition\myfolders\filename.xlsx

and find it in UE as

/folders/myfolders/filename.xlsx

Re: Excel file uploaded in library successfully

Kurt_Bremser — Mon, 27 Jul 2020 16:15:51 GMT

You do not (I repeat: NOT) use the Windows path, you have to use the UNIX path!!!!

No C:\something, /folders/myfolders!!!