topic Re: No matching members in directory in SAS Procedures

No matching members in directory

pattubie — Wed, 26 Aug 2015 18:29:12 GMT

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;

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

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

63 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: No matching members in directory

pattubie — Wed, 26 Aug 2015 19:30:57 GMT

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

Re: No matching members in directory

data_null__ — Wed, 26 Aug 2015 19:40:16 GMT

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.

Re: No matching members in directory

pattubie — Wed, 26 Aug 2015 19:54:20 GMT

Hello data_null,

the files in the Youssef library are;

CRF1.xlsx

CRF2.xlsx

CRF3.xlsx.

Re: No matching members in directory

data_null__ — Wed, 26 Aug 2015 20:08:31 GMT

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.