Macro variable with multiple values

[greg6363]

I was able to get access to a database but it contains 276 separate tables. In order to see what variables are in each table, I can use PROC CONTENTS to get a list of said variables but it’s too laborious to write a PROC CONTENTS statement for each table. Is it possible to create a macro with a macro variable called TABLE in order to call the name of each individual table from a list? Any assistance is appreciated. Thanks.

[PaigeMiller]

No macros needed.

Issue the proper LIBNAME statement to connect to this database. Then find the view named SASHELP.VCOLUMN and look at that. All the information about the variables and the tables in this database is in there.

[SASKiwi]

What is your objective? To write queries of these tables or something else? What database are you accessing?

[Astounding]

PROC CONTENTS contains a shortcut for doing exactly what you want:

proc contents data=libname._all_ ;
run;

[greg6363]

I thought you could only use the _all_ in a PUT statement. Let me give it a try. Thanks.