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

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

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

View all other training opportunities.

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