Columns grouping in a column

[Siddhartha]

I have four columns named prd_grp,prd-subgroup,prd_desc and
loan_amount.
The output columns in sequence are: Item Total Loan_amount
The data is as follows:

prd_grp prd_subgroup prd_desc loan_amount


ASSETS All_Other Loans 234
ASSETS All_Other abc 345
ASSETS All_Other Quoted_Shares 213
LIABILIITES Deposits Current_Deposs 435
LIABILIITES Deposits Fixed 325
LIABILIITES Deposits NIDs & Repos 256
LIABILIITES Deposits Savings 218

I want the output with Item,total and loan_amount columns:
Below is the output I needed


Item Total Loan_amount


ASSETS
All_Other
Loans 234
abc 345
Quoted_Shares Held 213
Total 692
LIABILIITES
Deposits
Current Deposits 435
Fixed 325
NIDs & Repos 256
Savings 218
Total 1234


Can anone help me on this,as this is critical.
Thanks in advance.

[ArtC]

Please see the response to the same OP in the Procedures Forum.
http://support.sas.com/forums/thread.jspa?threadID=12215&tstart=0

[Cynthia_sas]

This question was already posted in 2 different forums -- the SAS Procedures forum and the ODS and Reporting Forum. There is no need to post the same version of a previous question over and over again. People already responded to this question the first time you asked the question -and- they responded in both of the forums where you posted the question.

cynthia