DATA Step, Macro, Functions and more

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

Reply
Contributor
Posts: 42

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

Dear All,

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

Dataset1


Roll numberDobSalaryexperience
111/12/8725002
512/04/5634003
303/06/7912004
204/05/94445604
403/07/99129083
603/07/99129087


Regards,

S Ravuri.

Super Contributor
Posts: 1,636

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

what do you mean by "running total"?

Contributor
Posts: 42

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


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.

Respected Advisor
Posts: 3,124

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

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

Ask a Question
Discussion stats
  • 3 replies
  • 149 views
  • 0 likes
  • 3 in conversation