If I used this code:
Proc sgplot data=example;
scatter x=month y=total;
reg x=month y=total;
the reg statement would use all data point to plot regression line, but I want that it would use just first 59 point, but the line would plot for all datapoints. I want to see, if graphically it is visible that there is any change after point 60
To me, this graph looks like a TimeSeries forecast plot, with the fit computed from the data on the left, and projected into future. If you need the fit line computed this way, I suggest posting on the "SAS Forecasting and Econometrics" community.
If you have already computed the regression line as shown, then it is easy to plot it like you want using SGPLOT procedure. First, break up the Y data into two columns (Y1, Y2), one for the left dates (with missing values for the rest), one for the right. Then, use two series plot statements to draw each line, Y1 x date and Y2 x date using two different line patterns. With SAS9.40M3, you can use a block plot to draw the shaded regions and also draw the axis lines like in the graph by using the AxisExtent=Data option on the STYLEATTRS statement.
Use the BLOCK statement in PROC SGPLOT for the background. You can use style attributes and the GROUP= option in the SERIES statement to change the line style from solid to dashed:
data A; BlockID="History "; do x = 0 to 10 by 0.1; y = sin(x); output; end; BlockID="Prediction"; do x = 10 to 15 by 0.1; y = sin(x); output; end; run; ods graphics / attrpriority=none; proc sgplot data=A; styleattrs DATALINEPATTERNS=(solid dash); block x=x block=BlockID / transparency=0.5; series x=x y=y / group=BlockID lineattrs=(color=black thickness=3); run;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.