BookmarkSubscribeRSS Feed
Siddhartha
Calcite | Level 5
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.
2 REPLIES 2
ArtC
Rhodochrosite | Level 12
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
SAS Super FREQ
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

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 777 views
  • 0 likes
  • 3 in conversation