Hi guys
Could anyone tell me how to check what datasets located in a SAS folder such as WORK or sashelp.
I want to see the whole list of all dataset's names in sashelp folder
Thanks
It's pretty easy with a proc sql call, however it won't work unless the libname is in CAPS.
proc sql;
select memname
from dictionary.tables
where libname="SASHELP"
;
quit;
Arthur,
I think using MEMBERS table is pretty faster than TABLES table.
proc sql;
select memname
from dictionary.members
where libname="SASHELP"
;
quit;
Ksharp
And if you just want to see it, check the log.
proc datasets library=sashelp;
run;
Why not use proc contents? proc contents data=sashelp._all_; run;
Are you running SAS interactively? Then use the DIR command. DIR WORK or DIR SASHELP will pop up a list of the files in a library.
add the nods option to just get the list. you can also out= it to get a table.
proc contents data=sashelp._all_ nods; run;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.