Quickly get the variable names from datasets

[zimcom]

Hi Community,

I received 30 plus SAS datasets and want to quickly retrieve all the variable names of each datasets 

Is there a quick way to do this? 

Thanks as always

[Reeza]

Sure, create a libname to the folder and use SASHELP.VCOLUMN with the lists of all variables.

[zimcom]

SASHELP.VCOLUMN

how?

I am using SAS 9.4

Thanks

[Reeza]

proc sql;
create table want as
select *
from sashelp.vcolumn 
where libname = "LIBNAME";
quit;

I'm assuming you do know how to create a library references. Replace the libname in quotes with the libname you use in upper case and that should work. SASHELP is a default library available and you can navigate to the data sets to see what they contain.

---

@zimcom wrote:

SASHELP.VCOLUMN

how?

I am using SAS 9.4

Thanks

---

[Astounding · Accepted solution]

This will give you a little more than what you are requesting, but you will probably find it all useful:

libname me 'path to folder holding your SAS data sets';

proc contents data=me._all_;
run;

[zimcom]

@Astounding @Reeza 

THANK YOU BOTH, HAVE A GREAT WEEKEND!!