I thought this would be simple, but nothing I have tried works......I have hundreds of variables I need to rescale (1to 5 instead of 5 to 1). Calculation is easy: varnew=6 - varold. But I don't want to do that several hundred times. I was trying to put the list of variable names in a macro variable and then break that apart using a scan function. Then I was adding an 'r' as a suffix and calculating the new value for that variable based on the old. I need to keep both variables. Any ideas? I would post what I tried but network went down so I can't retrieve right now. Thanks in advance for any thoughts.
Don,
Would something like the following do what you need?
data have;
input x y z;
cards;
1 2 3
5 2 1
4 3 4
;
data want (drop=i);
set have;
array recode(*) _numeric_;
do i=1 to dim(recode);
recode(i)=6-recode(i);
end;
run;
Don,
I didn't notice the part that you wanted to keep the original variables. There may be an even easier way but, as long as you can enter the starting and ending variables, then you may be able to use something like:
data have;
input x y z;
cards;
1 2 3
5 2 1
4 3 4
;
proc sql noprint;
select strip(name)||"=r_"||strip(name),strip(name)
into :renames separated by " ",
:keeps separated by " "
from dictionary.columns
where libname="WORK"
and memname="HAVE"
and type="num"
;
quit;
data want (drop=i);
set have;
set have (keep=&keeps. rename=(&renames.));
array recode(*) r_x--r_z;
do i=1 to dim(recode);
recode(i)=6-recode(i);
end;
run;
Art,
Thanks for the ideas! There were a couple of peculiarities in my data, but I was able to take your idea and make it work perfectly! For some reason I was stuck in a specific thought pattern. Thanks again!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.