BookmarkSubscribeRSS Feed
sambasiva_ravuri_tcs_com
Calcite | Level 5

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.

3 REPLIES 3
sambasiva_ravuri_tcs_com
Calcite | Level 5


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.

Haikuo
Onyx | Level 15

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1096 views
  • 0 likes
  • 3 in conversation