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 (572 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 (553 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-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Upcoming Events
View All
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
  • 573 views
  • 0 likes
  • 2 in conversation