Help using Base SAS procedures

No matching members in directory

Reply
New Contributor
Posts: 3

No matching members in directory


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        

New Contributor
Posts: 3

Re: No matching members in directory

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
Respected Advisor
Posts: 3,799

Re: No matching members in directory

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.

New Contributor
Posts: 3

Re: No matching members in directory

Posted in reply to data_null__

Hello data_null,

the files in the Youssef library are;

CRF1.xlsx

CRF2.xlsx

CRF3.xlsx.

Respected Advisor
Posts: 3,799

Re: No matching members in directory

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.

Ask a Question
Discussion stats
  • 4 replies
  • 900 views
  • 0 likes
  • 2 in conversation