Table names

BrahmanandaRao · Posted 03-20-2021 09:07 AM

How to get all table names using proc sql

i think

proc sql ;

dictionary.tables ;

quit;

mkeintz · Posted 03-20-2021 09:47 AM

@BrahmanandaRao wrote:

How to get all table names using proc sql

i think

proc sql ;

dictionary.tables ;

quit;

And what happened when you tried it?

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Kurt_Bremser · Posted 03-20-2021 10:04 AM

SELECT statement in PROC SQL.

We have already given you examples for using the dictionary tables in previous questions.

Re: Table names