sas

[vinod4842]

Name Score
A     2B     3A     1B     3

I want a query which give the following output.

Name Score
A     2A     1Subtotal 3B    3B    3Subtotal 6

Please help me with an procSQL code

[PaigeMiller]

---

@vinod4842 wrote:

Name Score
A     2B     3A     1B     3

I want a query which give the following output.

Name Score
A     2A     1Subtotal 3B    3B    3Subtotal 6

Please help me with an procSQL code

---

Please help me by explaining how you get the output from the input.

[Reeza]

Instead of recieving an answer you're seeing this post because your question is unclear. 

Please take the time to properly explain your question, provide sample input and output data where appropriate, and detail your logic. Without this we are forced to guess what you want. Or we just ignore your question. It's in your best interest to take the time to do so.