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.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.