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.
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;
I think we shoud assign value of vara to varb just like this
data want;
set have;
b=a;
run;
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!
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!
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.
Ready to level-up your skills? Choose your own adventure.