I want to visualize a funds tracker (example given in screenshot).
Planning to use path analysis for the same. But not getting correct visualization. Can someone suggest if we can achieve it and how?
Hi, Yes, I believe this should be possible - the screenshot you provided shows a generic sankey diagram. What exactly are you struggling with? Maybe you can provide some details e.g. snapshot of the data.
You may also find some related discussions useful as those cover details such as expected data structure and role assignments:
Hope this helps. Falko
Thanks for your response. All the examples i saw shows the progress of events. What i want to show is a transnational database:
Tx id Date Sender Address Reciever Address Amount
|312314||30-Sep-19||Kingfisher Airlines (KFA)||Arielle Sixsmith||89.1243|
|312315||1-Oct-19||Kingfisher Airlines (KFA)||Michael Vincent Hazel||46.876|
|312316||2-Oct-19||Kingfisher Airlines (KFA)||Catherine Kelsey Prescott||72.72727|
|312317||3-Oct-19||Kingfisher Airlines (KFA)||Ashley Simon Kaniewski||61.70213|
|312318||4-Oct-19||Kingfisher Airlines||Haydn Simpson||25.1324|
|312319||5-Oct-19||Kingfisher Enterprises||Paul Telford||20.136|
|312320||6-Oct-19||Kingfisher Enterprises||Masroor Ahmed Siddiqui||87.12374|
|312321||7-Oct-19||Kingfisher Enterprises||Hameeda Asif||70.5693|
|312322||8-Oct-19||Kingfisher Enterprises||Anila Gulzar||6.25|
|312323||9-Oct-19||Kingfisher Enterprises||Abdul Aziz||77.77778|
|312324||10-Oct-19||Kingfisher Enterprises||Asma Noor Ahmed Bharuchi||83.92857|
|312325||11-Oct-19||Kingfisher Services Limited||Pinhas Schapira||81.81818|
|312326||12-Oct-19||Kingfisher Services Limited||Igal Mark Scheinberg||6.52174|
|312327||13-Oct-19||Kingfisher Services Limited||Rafael Ashkenai||11.76471|
I want the flow going from Sender address to receiver address with amount defining thickness. Unable to define such a flow.
Well, I don't think your data structure is suitable for path analysis. A sankey diagram is a bit like a network diagram as it shows lines (paths) between nodes (events) appearing over time. So for instance an event (e.g. a product purchase, a registration, a cancellation, etc.) which occurs over and over again during a specific time period. A sankey diagram would show you the number of people going thru such an event - so you can measure effectiveness or general volume.
In your case - you have a transaction data base with a distinct event per transaction. I'm not sure what output you would expect given your sample data - but given your 4x senders (transaction identifiers) and receivers (events) - it would render like this:
Given a receiver doesn't appear more than once in your data across different senders - the sankey never connects paths here. Hence you have such horizontal lines here - one for each sender.
You may also consider using a network visualization instead. Given your 4x senders and amount sent to an address - it may render like this:
It doesn't do too well with dates/times but may still be useful to see overall relationship between senders/receivers.
Sankey diagrams are mostly used to visualize paths (hence you find this under path analysis in VA) - so it may not be as useful for visualizing a distinct list of unique transaction details.
Hope this helps. Regards, Falko
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.