topic Re: How do I plot multiple(by group) adjusted trend line one graph? in Graphics Programming

How do I plot multiple(by group) adjusted trend line one graph?

pearson101 — Fri, 15 Jan 2021 18:00:40 GMT

Hello,

I am trying to code a a trend line for multiple districts in one graph. I have used a similar code for the trend line for individual plot and it works. The problem I am trying to add the 'district' variable in the proc x11 state. Right now 'district' is not added to my proc x11 statement. I'd appreciate your insight on how to add the 'district 'variable.

```

proc x11 data = causerie_t_total_mean_all noprint;
monthly additive date = date;
var mean_cough_rate;
tables a1 d12;
output out = test_all_cold a1 = mean_coldcough_rate d12 = adj;run;
title 'Trend line for the proportion of cough, by district';
proc sgplot data=test_all_cold;
series x=date y= adj / group=district markers legendlabel="trend cycle";
xaxis label='Date';
yaxis label='Proportion of cough';
run;

````

Re: How do I plot multiple(by group) adjusted trend line one graph?

DanH_sas — Fri, 15 Jan 2021 18:23:41 GMT

If you add the "district" variable to a BY statement in PROC X11, does the output data set contain the calculations per district? If so, you can plot those results in PROC SGPLOT.

Hope this helps!

Dan

Re: How do I plot multiple(by group) adjusted trend line one graph?

pearson101 — Fri, 15 Jan 2021 18:28:19 GMT

Hello, when I type by district, it produced a output for only one of the district. Is it possible to include the district variable in oneput data such that I can code something like?:

proc sgplot data=test_all_cold;
series x=date y= adj / group=district markers legendlabel="trend cycle";run;

Re: How do I plot multiple(by group) adjusted trend line one graph?

DanH_sas — Fri, 15 Jan 2021 18:37:48 GMT

Try two things:

1. add the ID statement to the proc:

ID district;

2. Make sure that your input data is sorted by the "district" variable.

Re: How do I plot multiple(by group) adjusted trend line one graph?

pearson101 — Fri, 15 Jan 2021 18:52:11 GMT

Thank you for your help!