01-18-2017 07:08 AM
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.
01-18-2017 07:17 AM
Please supply example data in a data step and what the resulting dataset should look like.
01-18-2017 07:27 AM - edited 01-18-2017 07:28 AM
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.