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;
````
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.
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
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;
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.
Thank you for your help!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.