topic Re: Rename in SAS Procedures

Rename

robertrao — Thu, 06 Jun 2013 06:49:25 GMT

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;

Re: Rename

LinusH — Thu, 06 Jun 2013 10:09:50 GMT

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.

Re: Rename

Oleg_L — Thu, 06 Jun 2013 10:38:32 GMT

You missed parentheses:

set have(rename=(inner=in outer=out) );