https://communities.sas.com/t5/SAS-Programming/Extract-tables/m-p/796957#M255799 <P>HI Every, Need your help. I have data as show below</P><P>&nbsp;</P><P>&nbsp;from univ. abcd a</P><P>left join univ.text&nbsp; b on a.x=b.x left join earth.euro</P><P>&nbsp;</P><P>I need to pull list of all schemas and table names in that data. Reason for this they are shifting our data bases want to know the impact of tables list. Could some one help me how to achieve this</P><P>&nbsp;</P><P>output:</P><P>univ.abcd</P><P>univ.text earth.euro</P> Thu, 17 Feb 2022 18:32:32 GMT samanvi 2022-02-17T18:32:32Z https://communities.sas.com/t5/SAS-Programming/Extract-tables/m-p/796957#M255799 <P>HI Every, Need your help. I have data as show below</P><P>&nbsp;</P><P>&nbsp;from univ. abcd a</P><P>left join univ.text&nbsp; b on a.x=b.x left join earth.euro</P><P>&nbsp;</P><P>I need to pull list of all schemas and table names in that data. Reason for this they are shifting our data bases want to know the impact of tables list. Could some one help me how to achieve this</P><P>&nbsp;</P><P>output:</P><P>univ.abcd</P><P>univ.text earth.euro</P> Thu, 17 Feb 2022 18:32:32 GMT https://communities.sas.com/t5/SAS-Programming/Extract-tables/m-p/796957#M255799 samanvi 2022-02-17T18:32:32Z https://communities.sas.com/t5/SAS-Programming/Extract-tables/m-p/796960#M255801 If you can run the code take a look at PROC SCAPROC.<BR /><BR /><A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/p0sf63lx4fs2m5n14qv1bn8p863v.htm" target="_blank">https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/p0sf63lx4fs2m5n14qv1bn8p863v.htm</A> Thu, 17 Feb 2022 18:37:43 GMT https://communities.sas.com/t5/SAS-Programming/Extract-tables/m-p/796960#M255801 Reeza 2022-02-17T18:37:43Z