Hello all,
I hope everyone's day is going great. I have a question regarding libraries. I am trying to find a particular field name that provides the data I need within a data set. The issue is I have no idea what data set the information is stored on. Is there any SAS features or code I can use to find it? Many thanks.
Sincerely,
Rob
Look in SASHELP.VCOLUMN.
It will show all columns in all data sets in currently assigned libraries.
Look in SASHELP.VCOLUMN.
It will show all columns in all data sets in currently assigned libraries.
Thanks Jerry and Sandy. This is exactly what I am looking for! Have a great day.
/*write below code for descriptive information - you may wants to define appropriate library before running this step*/
proc contents data=libref.datasetname;
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.