DATA Step, Macro, Functions and more

Columns grouping in a column

Reply
Contributor
Posts: 69

Columns grouping in a column

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.
Valued Guide
Posts: 632

Re: Columns grouping in a column

Please see the response to the same OP in the Procedures Forum.
http://support.sas.com/forums/thread.jspa?threadID=12215&tstart=0
SAS Super FREQ
Posts: 8,743

Re: Columns grouping in a column

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
Ask a Question
Discussion stats
  • 2 replies
  • 120 views
  • 0 likes
  • 3 in conversation