Lesson 2: Accessing Data, Activity

[potato]

This is the activity: 

Write a LIBNAME statement to create a library named NP that reads np_info.xlsx in the course data as follows:

• SAS Studio: Specify the full path to your EPG194/data folder and the complete file name.

My code is this and it should be the right file path but still there are no tables in the NP library.

libname np xlsx "/home/userid/EPG194/data/np_info.xlsx";

[Jagadishkatam]

please follow below code

/* because Excel field names often have spaces */
options validvarname=any;
 
libname np XLSX '/home/userid/EPG194/data/np_info.xlsx';
 
/* discover member (DATA) names */
proc datasets lib=np; quit;
 
libname np CLEAR;

Once the library is assigned, we can read the contents of a spreadsheet into a new SAS data set:

/* because Excel field names often have spaces */
options validvarname=any;
 
libname np XLSX '/home/userid/EPG194/data/np_info.xlsx';
 
/* read in one of the tables */
data datasetname;
  set np.datasetname;
run;
 
libname np CLEAR;