08-26-2015 02:29 PM
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:
Physical Name: D:\\Users\\patience.tubie\\SAS Data Sets
60 proc contents data=youssef._all_;
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;
08-26-2015 03:30 PM
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;
|Physical Name||D:\Users\patience.tubie\SAS Data Sets|
|Filename||D:\Users\patience.tubie\SAS Data Sets|
08-26-2015 03:40 PM
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.
08-26-2015 04:08 PM
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;
I don't know if that is exactly correct (RTM). Bottom line is you don't have SAS data sets.