Date:         Thu, 9 Feb 2006 05:30:35 -0500
Reply-To:     Eric Hoogenboom <erichoogenboom@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Eric Hoogenboom <erichoogenboom@YAHOO.COM>
Subject:      Re: Reduce variable length in transposed dataset?

Ben,

something to start with. Extensive help will follow when the overseas macro
dept of SAS-L enters the building.

proc sql;
   select distinct name into :nrcharvar, :varnames separated by ","
     from sashelp.vcolumn
    where libname = "WORK"
      and memname = "IT"
      and type = "char";
quit;

%put &varnames;

Using the %scan function you can loop over all vars.

Hth,
Eric