BookmarkSubscribeRSS Feed
RamKumar
Fluorite | Level 6

I need to understand the SAS code to copy the column value from one to other like below.

Assume i've a table called 'one' with values like below.

a b

1 2

3 4

5 6

I need to copy the column values from a to b and the output should be like

a b

1 1

3 3

5 5

Please suggest the SAS code to achieve this.

3 REPLIES 3
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Well I assume b in the second table is b from the first table - 1 so:

data want (rename=(new_b=b));

     set have;

     new_b=b-1;

run;

hello_fj
Calcite | Level 5

I think we shoud assign value of vara to  varb  just like this

data want;

set have;

b=a;

run;

ShreyasTare
Calcite | Level 5

If A and B column both are in same table then you can try following code :

 

data want;
set have;
array new{1} a;
b = sum(of new{*});
run;

 

P.S. : I don't think its a proper way to copy columns though!

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

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
  • 3 replies
  • 10971 views
  • 0 likes
  • 4 in conversation