Date:         Mon, 11 Feb 2008 06:50:50 -0800
Reply-To:     raisins <raisins25@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         raisins <raisins25@YAHOO.COM>
Organization: http://groups.google.com
Subject:      Change a coloumn name to a macro variable
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hi,
I am stuck at changing a variable name to a macro variable:
ideally, I want to take N from my macro and append it to a string like
'PF'&n'DT'
I was able to get PF&nDT as a macro variable. ( In a very bad way,
better methods are welcome!)
%let myvar = PF&n ;
%let prefix = DT;
%put &myvar ;
%global newvar = &myvar&prefix ;
%put &newvar;


now I want to use it to rename a variable in Dataset,
i tried
data Subjsf (rename = (PFSnDT = symget('newvar')));
set Subjsf ;
run;

Thanks in advance!