SAS Tip: Easy Way to Get All Variable Names From a Dataset

SAS_Tipster — Thu, 05 Jul 2018 20:37:21 GMT

In the recent issue of SAS TechReport, there was a tip for using %sysfunc to get all the variable names from a dataset and store them in a single macro variable. In the referenced sample code there is an alternate way using the dictionary tables:

%macro getvars(dsn);
    %global vlist;
    proc sql;
        select name into :vlist separated by ' '
        from dictionary.columns
        where memname = upcase("&dsn");
    quit;
%mend;

This creates a macro variable called &vlist that will contain the names of all the variables in your dataset, separated by a space. If you want commas between the variable names, all you have to do is change the 'separated by' value from ' ' to ', '. The use of the upcase function in the where statement avoids problems with someone passing the dataset name in the wrong case. The global statement is needed since the macro variable created will not necessarily be available outside the macro without defining it as global.

This tip was originally posted by Susan M on sasCommunity.org.

Re: SAS Tip: Easy Way to Get All Variable Names From a Dataset

ballardw — Tue, 24 Nov 2020 23:28:31 GMT

Should include LIBNAME as well.

I know I have multiple libraries that might have the same data set names (related projects).

topic SAS Tip: Easy Way to Get All Variable Names From a Dataset in SAS Tips from the Community

SAS Tip: Easy Way to Get All Variable Names From a Dataset

Re: SAS Tip: Easy Way to Get All Variable Names From a Dataset