couldn't import excel file with libname.

[Kjfinny]

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.

[Jagadishkatam]

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

[Kjfinny]

the sheet name is also heart. thank you

[ed_sas_member]

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,

[ed_sas_member]

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

[Kjfinny]

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

[Kurt_Bremser · Accepted solution]

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.

[Kjfinny]

thank you and I will try.