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?
something to start with. Extensive help will follow when the overseas macro
dept of SAS-L enters the building.
select distinct name into :nrcharvar, :varnames separated by ","
where libname = "WORK"
and memname = "IT"
and type = "char";
Using the %scan function you can loop over all vars.