Dear All,
How can i create a new field called tot_sal in dataset1 and calculate running total using DATA Step only ?
Dataset1 | |||
Roll number | Dob | Salary | experience |
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 |
Regards,
S Ravuri.
what do you mean by "running total"?
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.
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.