BookmarkSubscribeRSS Feed
potato
Calcite | Level 5

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

 

 

1 REPLY 1
Jagadishkatam
Amethyst | Level 16

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;
Thanks,
Jag

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 622 views
  • 0 likes
  • 2 in conversation