topic Re: Draw tree based on simple relational table. in SAS Programming

Draw tree based on simple relational table.

Yura2301 — Thu, 27 Jan 2022 04:43:46 GMT

Hi ,

Would like to ask the best way to visualize the relations like:

data Relations;

RelationId= 1 ; From= 'Node 1' ;to= 'Node 2' ;Output;

RelationId= 2 ; From= 'Node 1' ;to= 'Node 3' ;Output;

RelationId= 3 ; From= 'Node 1' ;to= 'Node 4' ;Output;

RelationId= 4 ; From= 'Node 2' ;to= 'Node 4' ;Output;

run;

In the end I would like to have graph or tree like that:

Offcourse ideally will be if links will not cross etc. I see there are a lot of options, proc sgplot proc ,proc gtree , hpsplit etc.

Looked a bit deeper to sgplot , built approximately needed tree but the view complitely not scalable, plus requires manually calculating X and Y axis, nodes names looks like can't be placed inside of nodes(like on image above) etc., so I just hope maybe there is some more logical and elegant way for the simple goal.

Thanks in adwanced for any advices!

Re: Draw tree based on simple relational table.

Ksharp — Thu, 27 Jan 2022 13:38:55 GMT

https://communities.sas.com/t5/SAS-Global-Forum-Proceedings/Methods-of-a-Fully-Automated-CONSORT-Diagram-Macro-CONSORT/ta-p/726358

Re: Draw tree based on simple relational table.

Yura2301 — Thu, 27 Jan 2022 13:46:21 GMT

Hi Kharp,

Thanks a lot, it looks like exactly what was needed!

Re: Draw tree based on simple relational table.

Ksharp — Fri, 28 Jan 2022 11:50:15 GMT

Also could check this one .

https://blogs.sas.com/content/graphicallyspeaking/2016/05/02/directed-link-networks/

Re: Draw tree based on simple relational table.

Yura2301 — Fri, 28 Jan 2022 14:57:07 GMT

Hi Ksharp,

Thanks for the input.

Already tried the sgplot procedure and drows the basic diagrams, as was needed.

But when there are a lot of nodes, links(relations between objects) - the diagram not scalable, nod readble, lines crosses etc.

Generally I hoped that maybe there are ready procedure that took relations table and build the tree in smart way, so doing all tech. pre-tasks for you, taking into consideration basic tree traversal properties like - number of child nodes, depth of tree etc.

Instead sgplot procedure requires partly manually calcualte X Y axis, take into consider size of page, ODS(in physical image - view can be readble but in SAS EG outptut -nop, and reversally etc.).

I've found a few third-party tools that do the drawing of diagram, but generally I just really wonder that SAS doesn't have so obvious feature ready, like a bit strange do not have that feature but to have cool and powerfull f.e. proc forecast and tens of other procedures that BI/DB developer will not find in any other products, but it's just thoughts in loud:), I 'm sure there are serious arguments why the procedure not ready yet, f.e. if it's 500 nodes and 1000 relations - draw it correctly and readable - chanlanging for sure.

Have a nice weekend!

Re: Draw tree based on simple relational table.

Ksharp — Sat, 29 Jan 2022 05:27:34 GMT

You could try this one

But I never used it before.

And if you have SAS/EM ,you also could try LINKED node (search it documentation at support.sas.com ).