https://communities.sas.com/t5/New-SAS-User/Field-List-by-Table/m-p/740251#M29038 <P><SPAN>Is there a way to generate a Field list by Table?&nbsp; 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.&nbsp; I'm using DI Studio 4.904.</SPAN></P> Mon, 10 May 2021 19:30:06 GMT huntlake 2021-05-10T19:30:06Z https://communities.sas.com/t5/New-SAS-User/Field-List-by-Table/m-p/740251#M29038 <P><SPAN>Is there a way to generate a Field list by Table?&nbsp; 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.&nbsp; I'm using DI Studio 4.904.</SPAN></P> Mon, 10 May 2021 19:30:06 GMT https://communities.sas.com/t5/New-SAS-User/Field-List-by-Table/m-p/740251#M29038 huntlake 2021-05-10T19:30:06Z https://communities.sas.com/t5/New-SAS-User/Field-List-by-Table/m-p/740263#M29040 <P>Check out the dictionary.column or sashelp.vcolumn tables which have metadata on the tables.&nbsp;</P> <P>&nbsp;</P> <P>There's also a nifty macro in the Community KnowledgeBase that creates a nice list in Excel or a data set for you.</P> Mon, 10 May 2021 19:58:41 GMT https://communities.sas.com/t5/New-SAS-User/Field-List-by-Table/m-p/740263#M29040 Reeza 2021-05-10T19:58:41Z