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 (462 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 (443 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-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

Register now

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