Desktop productivity for business analysts and programmers

Finding a specific field in a Library

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

Finding a specific field in a Library

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


Accepted Solutions
Solution
‎10-27-2013 09:13 PM
Frequent Contributor
Posts: 85

Re: Finding a specific field in a Library

Look in SASHELP.VCOLUMN.

It will show all columns in all data sets in currently assigned libraries.

View solution in original post


All Replies
Solution
‎10-27-2013 09:13 PM
Frequent Contributor
Posts: 85

Re: Finding a specific field in a Library

Look in SASHELP.VCOLUMN.

It will show all columns in all data sets in currently assigned libraries.

New Contributor
Posts: 4

Re: Finding a specific field in a Library

Thanks Jerry and Sandy.  This is exactly what I am looking for!  Have a great day.

Regular Contributor
Posts: 220

Re: Finding a specific field in a Library

/*write below code for descriptive information - you may wants to define appropriate library before running this step*/

proc contents data=libref.datasetname;

run;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 302 views
  • 5 likes
  • 3 in conversation