*---Get variable information for all data sets in a library;

 

libname test '...\sasdata' ;

 

%macro getvarnm( lib );

  options ls = 200 ps =60 ;

  proc sql;

    select *

        from sashelp.vcolumn

        where libname = %upcase("&lib")

          and memtype = 'DATA';

  quit;

%mend getvarnm;

 

*--Run macro;

%getvarnm( test ) ;