topic How can i create a new field called tot_sal in dataset1 and calculate running total using DATA Step? in SAS Programming

How can i create a new field called tot_sal in dataset1 and calculate running total using DATA Step?

sambasiva_ravuri_tcs_com — Tue, 13 Mar 2012 14:17:25 GMT

Dear All,

How can i create a new field called tot_sal in dataset1 and calculate running total using DATA Step only ?

Regards,

S Ravuri.

Linlin — Tue, 13 Mar 2012 14:23:17 GMT

what do you mean by "running total"?

Haikuo — Tue, 13 Mar 2012 14:29:21 GMT

Try this:

data have;

input Rollnumber $ Dob :$10. Salary experience;

cards;

1 11/12/87 2500 2

5 12/04/56 3400 3

3 03/06/79 1200 4

2 04/05/94 44560 4

4 03/07/99 12908 3

6 03/07/99 12908 7

;

data want;

set have;

tol_sal+salary;

run;

proc print;run;

Regards,

Haikuo

sambasiva_ravuri_tcs_com — Tue, 13 Mar 2012 14:30:29 GMT

Running Total means, for example sam is having sal of 25 as a first record and kemp is having sal of 35 and steve is having sal of 40.

I should get the output like for Running Total as

25 - for the first record.

60 - (25 +35) for the second record

100 - (60 +40) for the third record and so on.

Regards,

S Ravuri.