Hi,
This is a program to transpose using arrays
can i rename in the SET statement and use the renamed variables in the same datastep like shown(i used them as list of variables in the array???
Thanks
data want;
set have(rename=(inner=in outer=out);
by mrn1;
array val {2} in out ;
if first.mrn1 then cnt=0;
cnt+1;
do i = 1 to dim(val);
serial= cnt;
vpfx = vname(val{i});
vnttm= datepart(val{i});
output want;
end;
Funny, you have program and ask if it's works..? Why don't you just try it?
But from a conceptual view, the data step (which uses the PDV) will not know about the original names. So after a rename, only the new names is available for your program logic.
Funny, you have program and ask if it's works..? Why don't you just try it?
But from a conceptual view, the data step (which uses the PDV) will not know about the original names. So after a rename, only the new names is available for your program logic.
You missed parentheses:
set have(rename=(inner=in outer=out) );
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.