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) );
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.