BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
robertrao
Quartz | Level 8

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;

1 ACCEPTED SOLUTION

Accepted Solutions
LinusH
Tourmaline | Level 20

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.

Data never sleeps

View solution in original post

2 REPLIES 2
LinusH
Tourmaline | Level 20

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.

Data never sleeps
Oleg_L
Obsidian | Level 7

You missed parentheses:

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

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1486 views
  • 3 likes
  • 3 in conversation