DATA Step, Macro, Functions and more

Sum salary after 2 observation

Reply
Contributor
Posts: 48

Sum salary after 2 observation

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.

Namesalary Namesalary
subrat10 subrat10
abhi20 abhi20
milan100 other1000
sam200   
sudhir300   
muna400   
Super User
Posts: 7,854

Re: Sum salary after 2 observation

Please supply example data in a data step and what the resulting dataset should look like.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Super User
Posts: 7,988

Re: Sum salary after 2 observation

[ Edited ]
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. 

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