cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
huntlake
Calcite | Level 5 huntlake
Calcite | Level 5

Field List by Table

Posted 05-10-2021 03:30 PM (672 views)

Is there a way to generate a Field list by Table?  I'm looking to generate a dynamic data set that will allow me to quickly search to see what fields may be crossovers in more than one table.  I'm using DI Studio 4.904.

0 Likes
Reply
1 REPLY 1
Reeza
Super User Reeza
Super User

Re: Field List by Table

Posted 05-10-2021 03:58 PM (653 views)  |   In reply to huntlake

Check out the dictionary.column or sashelp.vcolumn tables which have metadata on the tables. 

 

There's also a nifty macro in the Community KnowledgeBase that creates a nice list in Excel or a data set for you.

0 Likes
Reply
Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Watch Mastering the WHERE Clause in PROC SQL on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • ‎05-10-2021 03:30 PM
  • 673 views
  • 0 likes
  • 2 in conversation