topic Re: Columns grouping in a column in SAS Programming

Columns grouping in a column

Siddhartha — Fri, 10 Dec 2010 15:46:21 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: Columns grouping in a column

ArtC — Fri, 10 Dec 2010 16:55:55 GMT

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

Re: Columns grouping in a column

Cynthia_sas — Fri, 10 Dec 2010 17:22:34 GMT

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