I see you are using proc transpose..... In that case look up prefix= option
in proc transpose.
AS to your second question we need to know more about the problem such as do
you want to look at col1 = col2, col1 = col3 etc... col1 = colN, and do the
same thing over again for col2 and col3 ... to colN?
From: Penn Whipple <pennwhip@YAHOO.COM>
Reply-To: Penn Whipple <pennwhip@YAHOO.COM>
Subject: Rename/reference variables dynamically?
Date: Fri, 13 Jan 2006 10:49:02 -0500
I have a data set where the transposed variables (mail dates) are called:
col1 col2 col3.... along with a match key variable.
What I would like help with is how to rename the transposed variables from
col1, col2, col3... to maildate1, maildate2, maildate3... dynamically.
I'd also like to be able to dynamically reference these variables (i.e. if
col1 = col2 then do something) if possible.
Since the number of transposed variables will change every time the data is
refreshed, it would be very nice to not have to hard code rename/if
statements every time.
I'm guessing an array would be a start but I hardly ever use them, so I
thought I'd ask the experts :)
Thanks in advance for the help.