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 (372 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 (353 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

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 373 views
  • 0 likes
  • 2 in conversation