I want to add salary after 2 observation as shown in below table
I want to create 2nd table out of 1st table which should add all salary , but 1t two observation should remain same.
| Name | salary | Name | salary | |
| subrat | 10 | subrat | 10 | |
| abhi | 20 | abhi | 20 | |
| milan | 100 | other | 1000 | |
| sam | 200 | |||
| sudhir | 300 | |||
| muna | 400 |
Please supply example data in a data step and what the resulting dataset should look like.
data want (drop=sum_sal);
set have end=last;
if _n_ in (1,2) then output;
else sum_sal=sum(sum_sal,salary);
if last then do;
name="Other";
salary=sum_sal;
output;
end;
run;
Note, not tested as no test data.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.