topic How to copy the column values from one to other? in SAS Procedures

How to copy the column values from one to other?

RamKumar — Thu, 31 Jul 2014 14:04:17 GMT

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.

RW9 — Thu, 31 Jul 2014 14:16:59 GMT

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 — Fri, 01 Aug 2014 02:19:40 GMT

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

data want;

set have;

b=a;

run;

ShreyasTare — Fri, 31 Aug 2018 09:46:51 GMT

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!