No matching members in directory

[pattubie]

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        

[pattubie]

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

Libref	YOUSSEF
Engine	V9
Physical Name	D:\Users\patience.tubie\SAS Data Sets
Filename	D:\Users\patience.tubie\SAS Data Sets

[data_null__]

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]

Hello data_null,

the files in the Youssef library are;

CRF1.xlsx

CRF2.xlsx

CRF3.xlsx.

[data_null__]

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.