topic Re: Can SAS create the attached the shapes of curvers? in Graphics Programming

Can SAS create the attached the shapes of curvers?

t75wez1 — Sat, 27 Oct 2018 22:21:16 GMT

Hi all,

I found one good graph described customer life value. I wonder if SAS can produce the similar shape of curves.

Sorry I don't have any data.

Any suggestions?

Thanks,

Ethan

Re: Can SAS create the attached the shapes of curvers?

DanH_sas — Sun, 28 Oct 2018 01:12:21 GMT

Here are some thoughts for you using SGPLOT overlays:

1. The "Profit" area can be done using using a BAND plot with a constant lower value (lower=0, for instance)

2. The line curves can be done using SERIES plots. I would use the SMOOTHCONNECT option to keep them smooth

3. The arrows can be drawn using a HIGHLOW plot, using TYPE=BAR and HIGHCAP=FILLEDARROW

Hope this helps!

Dan

Re: Can SAS create the attached the shapes of curvers?

t75wez1 — Sun, 28 Oct 2018 19:11:31 GMT

Dan,

Thanks a lot. Very helpful suggestion.

I started developing the attached code that seems accomplish the 1) you mentioned.

But I don't know how to put all together.

Could you offer further helps for 2) and 3)?

Regards,

Ethan

Re: Can SAS create the attached the shapes of curvers?

DanH_sas — Mon, 29 Oct 2018 17:53:43 GMT

Using your code, I added some extra data so that you can see how the other two plots can be used.

%let THRESHOLD = 0;
data wave;
t=0;
do x=0 to 6 by .05;
y=sin(0.5*x);
y2=sin(0.5*x) + 0.5;
if t = 20 then do;
   upper = y2;
   lower = y;
   t = 0;
end;
else do;
   upper=.;
   lower=.;
   t=t+1;
end;
positive = y;
negative = &THRESHOLD;
;
output;
end;
run;

ods path(prepend) work.templat(update);
proc template;
   define style mystyle;
   parent=styles.sasweb;
      class graphwalls /
            frameborder=off;
      class graphbackground /
            color=white;
   end;
run;

ods listing close;
ods html style=mystyle path='.' file='newgraph.html';
ods graphics / reset=all border=off width=600px height=400px imagename="cdh2";
proc print data=wave; run;
proc sgplot data=wave noautolegend;

YAXIS  DISPLAY=NONE  LABEL = " "  ;
XAXIS   DISPLAY=NONE LABEL = " "  ;
band x=x lower=&THRESHOLD
upper=positive / transparency=0.5;
band x=x lower=negative
upper=&THRESHOLD /
transparency=0.5;
series x=x y=y2 / smoothconnect lineattrs=(color=blue thickness=3);
highlow x=x high=upper low=lower / type=bar highcap=filledarrow intervalbarwidth=30px;
title " ";
footnote "";
run;

ods html close;
ods listing;

Hope this helps!

Dan

Re: Can SAS create the attached the shapes of curvers?

t75wez1 — Mon, 29 Oct 2018 20:57:05 GMT

Thank to Dan for the great progress made so far. Now I understander how to put the 3 things together.

But if I want to make the graph more look like the attached graph from my initial post, my challenge is to figure out on how to create the data to form the curves in order to achieve the desired results since the curves are not symmetric.

I'm really apprecitive of any helps.

Ethan