I have two different tables and link them together to get
something that looks like this
ssn act code ppe emst
333-33-3333 02 33 1
333-33-3333 06 31 1
333-33-3333 09 1 1
444-33-3333 02 33 2
444-33-3333 06 32 2
444-33-3333 02 6 2
So what I need is the Sum of the ppe by SSN AND THEN KEEPING THE HIGHEST ACT CODE - BY THE HIGHEST ORGINAL PPE.
Can someone
something that looks like this
ssn act code ppe emst
333-33-3333 02 33 1
333-33-3333 06 31 1
333-33-3333 09 1 1
444-33-3333 02 33 2
444-33-3333 06 32 2
444-33-3333 02 6 2
So what I need is the Sum of the ppe by SSN AND THEN KEEPING THE HIGHEST ACT CODE - BY THE HIGHEST ORGINAL PPE.
Can someone