topic couldn't import excel file with libname. in SAS Studio

couldn't import excel file with libname.

Kjfinny — Wed, 13 May 2020 07:05:41 GMT

I am studying with this book 'SAS Certified Specialist Prep Guide: Base Programming Using SAS 9.4'

using the universal edition of SAS studio.

I did this problem with 'proc import file='

it didn't work and the solution of the book is below;

It creates the library but not file. please, someone knows the reason, explain to me.

Re: couldn't import excel file with libname.

Jagadishkatam — Wed, 13 May 2020 07:27:54 GMT

could you please check the tab name or excel sheet name in heart.xlsx, is there a tab name or excel sheet name as heart.

in order for you to read the excel file via libname you need to know the sheet name and use that sheet name as input dataset in set statement.

to know the different sheet names in the excel file try

proc datasets lib=certdata; 
quit;

This will give you the different table or sheet names in that excel file.Once you know the name replace that name in set certdata.xxxx

Re: couldn't import excel file with libname.

ed_sas_member — Wed, 13 May 2020 07:44:15 GMT

Hi @Kjfinny

I also experienced these inconsistencies with the book.

-> The dataset 'Aprbills' can be accessed with the libname 'Cert' and not 'Clinic'

-> The dataset 'Heart' for scenario 6 can be accessed with the libname 'Sashelp' (no Excel file supplied):

data work.heart;
	set sashelp.heart (drop=AgeAtDeath DeathCause);
	where status="Alive";
	...
run;

Best,

Re: couldn't import excel file with libname.

Kurt_Bremser — Wed, 13 May 2020 07:47:04 GMT

Please post your logs in the future not as pictures, but by copy/pasting the log text into a window opened with the </> button:

From the contents of your picture, I take it that you use University Edition in a virtual machine. To address files in the shared folder, you need to use the internal path of the VM, which is /folders/myfolders. The VM is a UNIX system, uses UNIX filename syntax, and does not have access to your local drives, only to the shared folder.

Re: couldn't import excel file with libname.

ed_sas_member — Wed, 13 May 2020 07:49:16 GMT

NB: You can check for updates here: https://support.sas.com/content/dam/SAS/support/en/books/errata-base-certified.pdf

Re: couldn't import excel file with libname.

Kjfinny — Wed, 13 May 2020 17:35:29 GMT

the sheet name is also heart. thank you

Re: couldn't import excel file with libname.

Kjfinny — Wed, 13 May 2020 17:42:07 GMT

scenario 6 need to use import data from an outside source.
but I will try~

Re: couldn't import excel file with libname.

Kjfinny — Wed, 13 May 2020 17:50:05 GMT

thank you and I will try.