octrout Tracker

Re: sum two columns from two tables

octrout — Wed, 03 May 2017 03:27:54 GMT

How do I subtract instead of sums ? Thanks !

/* Increment the sums and copy results back to NUM_A and NUM_B */
  do I=1 to dim(sums);
    sums{i}+nums{I};
    nums{I}=sums{I};
  end;

Re: sum two columns from two tables

octrout — Tue, 02 May 2017 20:23:17 GMT

Hi, Can this be done in data step ?

Re: replacing value using array or macro

octrout — Mon, 10 Apr 2017 20:03:51 GMT

Hi,

I have about 60 variables that need to replace with values from one variable.

This would be an example data set need to replace c,d,e,f,g with values from B. Thanks !

data have;
input A $ B C $	D E F G ;
datalines;
CA	1	1	1 20 7 10
CA	2	B	1 2 5 18
CA	3	B	9 3 5 18
CA	4	B	8 3 3 7
CA	6	R	2 4 2 6
NV	1	B	1 4 1 9
NV	2	B	1 4 1 10
NV	3	B	1 5 7 18
NV	4	B	1 5 4 8
NV	5	B	1 5 4 7
NV	6	B	1 5 6 8
NV	1	R	4 5 7 9
NV	2	R	6 5 8 10
;
run;

Re: replacing value using array or macro

octrout — Mon, 10 Apr 2017 18:49:39 GMT

Thanks for the reply. What if i have many variables to replace values ?

replacing value using array or macro

octrout — Mon, 10 Apr 2017 18:28:01 GMT

Hi, I would like to replace values in C and D with value from B. Can anyone help to create code using array or macro ? Thank you so much !

data have;
input A $ B C $	D ;
datalines;
CA	1	1	1
CA	2	B	1
CA	3	B	9
CA	4	B	8
CA	6	R	2
NV	1	B	1
NV	2	B	1
NV	3	B	1
NV	4	B	1
NV	5	B	1
NV	6	B	1
NV	1	R	4
NV	2	R	6
;
run;

computing sum and average by every nth row

octrout — Mon, 10 Apr 2017 04:44:51 GMT

Hi, I would like to compute sum ( bal_rev = R ) and average (bal_rev = B) by every 3 period for each state. Could you please help ? Thanks !

data have;
input State $ Period Bal_Rev $ AMOUNT;
datalines;
CA 1 B 1464.48
CA 2 B 1275.81
CA 3 B 943.28
CA 4 B 849.82
CA 5 B 752.29
CA 6 B 661.56
CA 1 R 4.86
CA 2 R 4.86
CA 3 R 4.3
CA 4 R 3.57
CA 5 R 3.19
CA 6 R 2.97
NV 1 B 1047.84
NV 2 B 1045.54
NV 3 B 1092.74
NV 4 B 1110.41
NV 5 B 1134.34
NV 6 B 1105.86
NV 1 R 4.91
NV 2 R 6.09
NV 3 R 6.8
NV 4 R 5.84
NV 5 R 7.22
NV 6 R 10.16
UT 1 B 9856.37
UT 2 B 9825.48
UT 3 B 9701.09
UT 4 B 9497.63
UT 5 B 9448.09
UT 6 B 9293.51
UT 1 R 13.09
UT 2 R 12.7
UT 3 R 11.35
UT 4 R 8.14
UT 5 R 16.72
UT 6 R 16.19
;
run;

data want;;
set have;
if bal_rev ='B' then do;
/* average value for every 3 period for each state */
end;
if bal_rev = 'R' then do;
/* sum value for every 3 period for each state */
end;
run;