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.
1 REPLY 1
Cynthia_sas
SAS Super FREQ
Hi:
Several answers have been posted to this example when you asked it in your 2 PREVIOUS forum postings. Did you try any of that code? Was there an issue with any of those responses or approaches?

Also, for "critical" or "urgent" help you should open a track with Tech Support. Forum participation happens when folks have time and the inclination to help. If you haven't looked at or tried anything that's already been suggested you may find that folks don't have much incliniation to help.

If there was an issue with any of the code posted in the other places, then it would have been better for you to continue the thread/conversation in the other posting, so people can see code that's already been suggested and that you seem to find unacceptable.

cynthia

Previous forum postings
SAS Procedures responses:
http://support.sas.com/forums/thread.jspa?threadID=12206&tstart=0 (3 postings)

ODS and Reporting responses:
http://support.sas.com/forums/thread.jspa?threadID=12186&tstart=0 (6 postings)

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 645 views
  • 0 likes
  • 2 in conversation