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

[pearson101]

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;

````

[DanH_sas]

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 

[pearson101]

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;

[DanH_sas · Accepted solution]

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.

[pearson101]

Thank you for your help!