Lesson 2: Accessing Data, Activity

potato — Sat, 30 May 2020 06:44:57 GMT

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";

Re: Lesson 2: Accessing Data, Activity

Jagadishkatam — Sat, 30 May 2020 07:05:53 GMT

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;

topic Re: Lesson 2: Accessing Data, Activity in New SAS User

Lesson 2: Accessing Data, Activity

Re: Lesson 2: Accessing Data, Activity