cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
hoaglam
‎04-20-2021
  • 5 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Subracting rows where duplicate values are present in a column

by Calcite | Level 5 in SAS Enterprise Guide
‎04-20-2021 10:58 AM
‎04-20-2021 10:58 AM
Thanks, I'll tinker with this concept to see if I can make some progress. ... View more

Re: Subracting rows where duplicate values are present in a column

by Calcite | Level 5 in SAS Enterprise Guide
‎04-20-2021 10:56 AM
‎04-20-2021 10:56 AM
Im using that unique key as a grouping only. The duplicates that I'm worried about are in the transaction values where both debits AND credits are present within the same account for the same amount. In the table I posted, the only duplicate I posted was for row 5. Row 5 should negate row 6 in this case, leaving a single transaction for that "new_key" group. ... View more

Re: Subracting rows where duplicate values are present in a column

by Calcite | Level 5 in SAS Enterprise Guide
‎04-20-2021 10:33 AM
‎04-20-2021 10:33 AM
Yes, that 353 is a transaction code that means "debit", which is also represented as a "D" in the "Debit Credit Indicator" column. ... View more

Re: Subracting rows where duplicate values are present in a column

by Calcite | Level 5 in SAS Enterprise Guide
‎04-20-2021 10:22 AM
‎04-20-2021 10:22 AM
Hi there. In the data I'm showing the duplicates I'm trying to remove are in rows 5, 6 and 7. In reality, we have a net $15,000 transaction. All three of these keys share the same "new_key" identifier, which is how I'm identifying duplicates. Hopefully thats helpful. Thanks again! ... View more

Subracting rows where duplicate values are present in a column

by Calcite | Level 5 in SAS Enterprise Guide
‎04-20-2021 10:05 AM
‎04-20-2021 10:05 AM
I've been working on a solution to subtracing duplicate credits from a ledger. Is anyone able to lend a hand on this? Sample data below: TRAN_CD TRAN_AMT DEBIT_CREDIT_INDICATOR new_key 776 40.00 C 109560357322350000000.00 776 40.00 C 109560357322350000000.00 776 40.00 C 109560357322350000000.00 776 40.00 C 109560357322351000000.00 353 15000.00 D 109560345122351000000000.00 753 15000.00 C 109560345122351000000000.00 753 15000.00 C 109560345122351000000000.00 776 29.00 C 1095603451223510000000.00 776 40.00 C 1095603451223510000000.00 776 40.00 C 1095603451223510000000.00   In the case of the $15000 transaction that occurred three times, I would want to basically negate the debit and one of the credits to show a net $15000 transaction, not $45000 worth of transactions. I concatenated a few feilds within the data to create a unique key that you see in the far right column. Very stuck. Any help is appreciated! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-20-2021 08:12 PM
Likes given to
View All
Quick links