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:
This goes somewhat further but maybe that is the purpose for which you want it.
Regards - Jim.
Jim Groeneveld, Netherlands
Statistician, SAS consultant
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:
>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.