Grouping within columns

Siddhartha — Fri, 10 Dec 2010 15:42:56 GMT

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.

Re: Grouping within columns

Cynthia_sas — Fri, 10 Dec 2010 16:40:09 GMT

Hi:
This question has already been asked and answered both times that you posted it in the SAS Procedures forum and in the ODS forum. Did you try any of the previously posted code?

For critical or urgent requests, your best resource is to open a track with Tech Support. Forum participation occurs as people have the time and inclination to help.

To open a track with Tech Support, fill out the form at this link:
http://support.sas.com/ctx/supportform/createForm

cynthia

topic Grouping within columns in SAS Procedures

Grouping within columns

Re: Grouping within columns