topic Quickly get the variable names from datasets in SAS Programming

Quickly get the variable names from datasets

zimcom — Fri, 26 Jul 2019 20:09:56 GMT

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

Re: Quickly get the variable names from datasets

Reeza — Fri, 26 Jul 2019 20:19:59 GMT

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

Re: Quickly get the variable names from datasets

zimcom — Fri, 26 Jul 2019 20:23:08 GMT

SASHELP.VCOLUMN

how?

I am using SAS 9.4

Thanks

Re: Quickly get the variable names from datasets

Astounding — Fri, 26 Jul 2019 20:24:21 GMT

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;

Re: Quickly get the variable names from datasets

Reeza — Fri, 26 Jul 2019 20:26:35 GMT

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

Re: Quickly get the variable names from datasets

zimcom — Fri, 26 Jul 2019 20:27:25 GMT

@Astounding @Reeza

THANK YOU BOTH, HAVE A GREAT WEEKEND!!