Background: I am reviewing a single, long SAS script that takes in 7 input SAS datasets, merges and manipulates them into dozens of intermediate temporary WORK datasets, and ultimately creates 3 output SAS datasets. Goal: My goal is to visualize how the original 7 input SAS datasets feed into the final 3 output SAS datasets. Additional details: These input datasets are from different libnames. They go through a number of DATA/PROC SQL steps that create intermediate datasets mostly through merges, with some data cleaning and sorting involved. What I want to see is a visual/flowchart that connects the inputs with outputs. For example, input datasets 1 and 3 “feed” into output dataset A, input datasets 2, 3, 4, and 6 “feed” into output dataset B, and input datasets 1, 4, 5, and 7 "feed" into output dataset C. What I have tried: I have tried to run this as a Process Flow in SAS Enterprise Guide. However, that seems designed around having many smaller SAS scripts linked in succession. For reasons outside of my control, I am limited to reviewing this one very long SAS code and would not be able to break it up into smaller scripts. I can edit the code if absolutely needed. Is there a way that such a visual or process flow can be created? Thank you.
... View more