BookmarkSubscribeRSS Feed
pattubie
Calcite | Level 5


Hello, I created a Libname it was successfully assigned but the data sets contained in it did not pull in.

        OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

57        

58          libname youssef 'D:\\Users\\patience.tubie\\SAS Data Sets';

NOTE: Libref YOUSSEF was successfully assigned as follows:

       Engine:        V9

       Physical Name: D:\\Users\\patience.tubie\\SAS Data Sets

59        

60          proc contents data=youssef._all_;

61          run;

WARNING: No matching members in directory.

NOTE: PROCEDURE CONTENTS used (Total process time):

       real time           0.06 seconds

       cpu time            0.04 seconds

      

62        

63         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

75        

4 REPLIES 4
pattubie
Calcite | Level 5

Hello mark,

Thank you for reaching out, I tried all the syntax you suggested but all the results still did not display the data sets in excel worksheets this is what I got;

  

Results: youssef.sas

The DATASETS Procedure

Directory Information

LibrefYOUSSEF
EngineV9
Physical NameD:\Users\patience.tubie\SAS Data Sets
FilenameD:\Users\patience.tubie\SAS Data Sets
data_null__
Jade | Level 19

Your SYNTAX is correct so that shouldn't be the issue. 

Are the files in the LIBRARY the correct type for a V9 library?  Show us a file-list.

Not sure about the use of double backslash?  SAS does report the LIBREF is created.

pattubie
Calcite | Level 5

Hello data_null,

the files in the Youssef library are;

CRF1.xlsx

CRF2.xlsx

CRF3.xlsx.

data_null__
Jade | Level 19

Those are not SAS data sets.  If you have the proper PC files software you can treat each XLSX as a data library where sheets and ranges are members. Something like this.

libname CRF1 excel 'D:\Users\patience.tubie\SAS Data Sets\CRF1.xlsx';

proc datasets library=CRF1;

     run;

     quit;

I don't know if that is exactly correct (RTM).  Bottom line is you don't have SAS data sets.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 3232 views
  • 0 likes
  • 2 in conversation