topic Re: SAS Plotter Update "Sankey diagram" in Graphics Programming

SAS Plotter Update "Sankey diagram"

SupermanJP — Sun, 09 Jun 2024 06:18:31 GMT

Hi. I'm SupermanJP.

I updated SAS plotter, modern data visualization package for SAS base.

https://github.com/Superman-jp/SAS_Plotter

document

https://superman-jp.github.io/SAS_Plotter/

new features

new plots " sankey diagram" was available!

official mail address: sasplotter@picolabs.jp
official web site (Japanese) https://picolabs.jp
Please feel free to contact me if you have any bug reports, feedback, or requests.

Re: SAS Plotter Update "Sankey diagram"

t75wez1 — Mon, 10 Jun 2024 14:05:03 GMT

Hello SupermanJP,

Nice work!

How to get your input data set named "raw" to your code?

Thanks,

Re: SAS Plotter Update "Sankey diagram"

SupermanJP — Tue, 11 Jun 2024 01:01:37 GMT

I apologize for the lack of clarity. i will revise the document.

"raw" dataset means input data you want to make sankey.

if you want to sankey using this macro, prepare the input data with structure.

Re: SAS Plotter Update "Sankey diagram"

t75wez1 — Tue, 11 Jun 2024 19:33:58 GMT

Sorry I mean to find the SAS data set named "raw" in your SAS code to replicate the graph here.

Thanks,

Re: SAS Plotter Update "Sankey diagram"

SupermanJP — Wed, 12 Jun 2024 15:26:57 GMT

the "raw" dataset is not included in SAS plotter package. sorry. I will add the raw dataset at next version.

Re: SAS Plotter Update "Sankey diagram"

GraphGuy — Fri, 14 Jun 2024 02:50:44 GMT

Examples are a *lot* more useful, when they include the sample data!

Re: SAS Plotter Update "Sankey diagram"

SupermanJP — Wed, 19 Jun 2024 04:29:49 GMT

Re: SAS Plotter Update "Sankey diagram"

SupermanJP — Wed, 19 Jun 2024 04:55:01 GMT

if you have additional idea, Please feel free to contact me.

by the way, you are so handsome.

Re: SAS Plotter Update "Sankey diagram"

yabwon — Wed, 19 Jun 2024 07:00:16 GMT

Raw data should look like in this example this:

data raw;
subjID+1;
input day0 day30 day60 day120;
cards;
0 2 3 4
0 2 3 4
0 2 3 4
2 1 2 4
2 1 2 4
2 1 2 4
2 1 2 4
2 1 2 4
2 1 4 3
4 3 2 1
4 3 2 1
4 3 2 1
4 3 2 1
;
run;

Basically each row (each subjid) indicates which drug was taken by a given patient during given time, e.g.

If patient 1 took drug 0 on the day 0, then drug 2 on the day 30, drug 3 on the day 60 and drug4 on day 120, the observation will be:

data raw;
input subjID day0 day30 day60 day120;
cards;
1 0 2 3 4
;
run;

Result of the following snippet:

proc format;
value domainf
1="day0"
2="day30"
3="day60"
4="day120";

value nodef
0="Drug A"
1="Drug B"
2="Drug C"
3="Drug D"
4="Drug E"
;
run;


data raw;
subjID+1;
input day0 day30 day60 day120;
format day0 day30 day60 day120 nodef.;
cards;
0 2 3 4
0 2 3 4
0 2 3 4
2 1 2 4
2 1 2 4
2 1 2 4
2 1 2 4
2 1 2 4
2 1 4 3
4 3 2 1
4 3 2 1
4 3 2 1
4 3 2 1
;
run;

ods graphics / height=15cm width=20cm imagefmt=svg imagename="sankey_basic" noborder;
ods listing gpath="R:\";
ods html;
%sankey(
    data=raw,
    domain=day0 day30 day60 day120,
    domainfmt=domainf
);

looks like this:

Bart

Re: SAS Plotter Update "Sankey diagram"

yabwon — Wed, 19 Jun 2024 07:22:28 GMT

One more example:

data raw;
  call streaminit(123);
  do subjID = 1 to 1000;
    array A day0 day30 day60 day120;
    format day0 day30 day60 day120 nodef.;
      do over A;
        A = rand('integer',0,4);
      end;
    output;
  end;
run;

which, with the same snippet, produces this:

Re: SAS Plotter Update "Sankey diagram"

SupermanJP — Thu, 20 Jun 2024 09:19:16 GMT

Thanks. Very informative.

Re: SAS Plotter Update "Sankey diagram"

t75wez1 — Mon, 08 Jul 2024 17:43:55 GMT

Hello SupermanJP,

1)How to add a title and footnote into the Sankey charts?

2)Howe to adjust the Sankey charts wider?

Thanks,

Re: SAS Plotter Update "Sankey diagram"

SupermanJP — Tue, 09 Jul 2024 02:33:21 GMT

1) you can use title statement or footnote statement.
but you want to add title or footnote into output image?
if you mean , this macro is not contained setting the title and footnote.

2) you mean you want to adjust the width of output image generated by sankey macro?
could you tell me the details?

Re: SAS Plotter Update "Sankey diagram"

t75wez1 — Tue, 09 Jul 2024 03:55:59 GMT

1)I tried to add title and footnote statements in the "proc template" of your Sankey macro code but I couldn't make it work.

2)I expect to adjust the width of Sankey chart similar to ods statement below used for "proc sgplot".

"ods graphics /imagefmt=png imagename="&name"
width=1500px height=800px;"

Thanks ,

Re: SAS Plotter Update "Sankey diagram"

SupermanJP — Tue, 09 Jul 2024 04:15:48 GMT

1) title string can be add by entrytitle statement in graph template.

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/grstatgraph/n0zp1mg0ard2dan17sohm8jb773n.htm

but I will add the title and footnote parameter to the sankey macro.

2 )
submit below code before executing the sankey macro.
"ods graphics /imagefmt=png imagename="&name"
width=1500px height=800px;"

Re: SAS Plotter Update "Sankey diagram"

SupermanJP — Tue, 09 Jul 2024 05:47:23 GMT

Re: SAS Plotter Update "Sankey diagram"

t75wez1 — Tue, 09 Jul 2024 13:19:09 GMT

Thank you so much for your insight.

Re: SAS Plotter Update "Sankey diagram"

SupermanJP — Sat, 13 Jul 2024 15:00:46 GMT

version 1.3 is available. I am revising document but program can be use.

https://github.com/SASPAC/sasplotter

please check the md files.

I added "note" parameter . this parameter insert the text statement into the graph template and display title or footnote.

Re: SAS Plotter Update "Sankey diagram"

t75wez1 — Sat, 13 Jul 2024 18:29:37 GMT

Hi Superman JP,

I saw "note=," parameter in version 1.3 but don't see your updated SAS Sankey macro code.

Looking forward to seeing how to use it exactly in Sankey document.

Thanks,

Re: SAS Plotter Update "Sankey diagram"

yabwon — Sat, 13 Jul 2024 20:01:08 GMT

Here is an instruction how to get version 1.3 in a form of a SAS package:

https://github.com/SASPAC/sasplotter/blob/main/sasplotter.md#install

Here is a snippet how to add footnote and title:

*--------------------------------------------------------;
*sankey example;
*--------------------------------------------------------;

proc format;
value domainf
1="day0"
2="day30"
3="day60"
4="day120";

value nodef
0="Drug A"
1="Drug B"
2="Drug C"
3="Drug D"
4="Drug E"
;
run;


data raw;
usubjid+1;
input day0 day30 day60 day120;
format day0 day30 day60 day120 nodef.;
cards;
0 2 3 4
0 2 3 4
0 2 3 4
2 1 2 4
2 1 2 4
2 1 2 4
2 1 2 4
2 1 2 4
2 1 4 3
4 3 2 1
4 3 2 1
4 3 2 1
4 3 2 1
;
run;
*--------------------------------------------------------;
*basic sankey;
*--------------------------------------------------------;
ods graphics / height=15cm width=20cm imagefmt=png imagename="sankey_basic" noborder;
title "Bacic Sankey";
ods html;
%sankey(
    data=raw,
    domain=day0 day30 day60 day120,
    domainfmt=domainf,
	note=%nrstr(entrytitle 'your title here';
			    entryfootnote halign=left 'your footnote here';
				entryfootnote halign=left 'your footnote here 2';)
	);