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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.