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;
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|
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.
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.
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.