Hi Eduardo,

How would you list the columns, or rather the variable names in a LIBNAME? I think you intended to say value of a variable, e.g. macro variable. Some time ago I already wrote a macro %DropMV that removes all variables (columns) with missing values for all records (rows) from a dataset: http://home.hccnet.nl/jim.groeneveld/software/SASmacro/DropMV.zip This goes somewhat further but maybe that is the purpose for which you want it.

Regards - Jim. -- Jim Groeneveld, Netherlands Statistician, SAS consultant home.hccnet.nl/jim.groeneveld

My computer and I present macro Count with SPSS-like syntax at PhUSE 2008.

On Wed, 17 Sep 2008 02:12:11 -0700, Eduardo <ejcalmeida@GMAIL.COM> wrote:

>Hi Guys, > >I need to list all the non empty columns in a libname. > >I am thougth I could create a table using dictionary.table and >dictionary.columns to create a temporary table with the name of each >table in the libname and the name of each column for each table. > >But since I am n00b at sas programming, I am having difficulties at >iterating my table. > >How can I do this. > >Thanks in advance.