topic Re: how to make reg line inclusive of entire year in sgplot in New SAS User

how to make reg line inclusive of entire year in sgplot

cmc_NYC — Tue, 11 Jan 2022 16:27:30 GMT

Hi All,

I've created a graphic showing results of an ITS showing the impact of an event on a population. This works as I want it to extend the line stops with 2016, and I'd like it to connect with the refline noting the event. Is this something I can do in my datalines or in the program below?

Data AimII_Table2;
input TimeElapsed Year Distress Event $;
datalines;
0 2011 3.7339771 Before
1 2012 3.8688698 Before
2 2013 3.8669976 Before
3 2014 3.5876379 Before
4 2015 3.64495 Before
5 2016 3.4850532 Before
6 2017 3.6610487 After
7 2018 3.5467001 After
;

Proc sgplot data=AimII_Table2;
Xaxis Values=(2011 TO 2018);
Yaxis Values=(1 TO 25);
reg x=Year y=Distress/group=Event ;
refline 2017 / axis=x label='Event' Transparency = 0.5;
Title'Distress over Time';
run;

Thank you!

Re: how to make reg line inclusive of entire year in sgplot

cmc_NYC — Tue, 11 Jan 2022 16:29:25 GMT

Here is the graph as it currently appears.

Re: how to make reg line inclusive of entire year in sgplot

PaigeMiller — Tue, 11 Jan 2022 16:30:40 GMT

You can modify the data. Note TimeElapsed=5 now appears twice, this causes the line to be extended to 2017.

Data AimII_Table2;
input TimeElapsed Year Distress Event $;
datalines;
0 2011 3.7339771 Before
1 2012 3.8688698 Before
2 2013 3.8669976 Before
3 2014 3.5876379 Before
4 2015 3.64495 Before
5 2016 3.4850532 Before
5 2017 3.4850532 Before
6 2017 3.6610487 After
7 2018 3.5467001 After
;

Re: how to make reg line inclusive of entire year in sgplot

cmc_NYC — Tue, 11 Jan 2022 17:09:03 GMT

Thank you!!!! That did it!