BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
pearson101
Calcite | Level 5

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;

````

 

1 ACCEPTED SOLUTION

Accepted Solutions
DanH_sas
SAS Super FREQ

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.

View solution in original post

4 REPLIES 4
DanH_sas
SAS Super FREQ

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
Calcite | Level 5

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
SAS Super FREQ

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
Calcite | Level 5

Thank you for your help!

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 467 views
  • 1 like
  • 2 in conversation