topic Re: Sum salary after 2 observation in SAS Programming

Sum salary after 2 observation

subrat1 — Wed, 18 Jan 2017 12:08:36 GMT

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

Re: Sum salary after 2 observation

Kurt_Bremser — Wed, 18 Jan 2017 12:17:12 GMT

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

Re: Sum salary after 2 observation

RW9 — Wed, 18 Jan 2017 12:28:19 GMT

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.