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-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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