topic Re: SGPLOT Refline in Graphics Programming

SGPLOT Refline

CEG — Fri, 10 Feb 2017 14:42:44 GMT

Hi,

I'm having a problem creating 2 reference lines.

The input for my X Axis looks like Datetime7: 01JUL15 through 30DEC16.

SGPLOT replaces Datetime7 with an auto-generated format. It looks like:

Jul Sep Nov Jan Mar May Jul ........................ Jan

2015 2016 2017

How do I create reference lines at 08FEB16 and 17MAR16?

I get errors when I use the numerics for those dates, use the actual Datetime7 dates, and when I just ask for FEB or MAR.

Thanks for any help you can give.

CEG

Re: SGPLOT Refline

Rick_SAS — Fri, 10 Feb 2017 15:12:44 GMT

Use the date literals:

'08FEB2016'D and '17MAR2016'D

For example:

proc sgplot data=sashelp.stocks;
series x=date y=close / group=stock;
refline '08FEB1993'D '17MAR2000'D / axis=X;
run;

Re: SGPLOT Refline

ballardw — Fri, 10 Feb 2017 15:18:08 GMT

Or for datetime values something like:

'10NOV05:00:00:00'dt

Re: SGPLOT Refline

CEG — Fri, 10 Feb 2017 15:38:41 GMT

By adding the 00:00:00, it gave me the 17MAR16 line; but it didn't create the 08FEB16 line.

The auto-generation gives me every other month which excludes FEB. Is there a way to override that?

Thanks!

Re: SGPLOT Refline

DanH_sas — Fri, 10 Feb 2017 16:02:13 GMT

You can use the INTERVAL option on the XAXIS statement to override the internally-determined time interval; however, since the time axis is continuous, the presence or absense of the FEB tick value should not affect the placement of the REFLINE.

Re: SGPLOT Refline

CEG — Fri, 10 Feb 2017 16:08:21 GMT

Thanks!

Can you think of anything else that could cause the FEB line to be ignored?

Re: SGPLOT Refline

DanH_sas — Fri, 10 Feb 2017 16:12:35 GMT

Is your input data in your X axis column in DATE or DATETIME format (not the column format, but the actual values)?

Re: SGPLOT Refline

CEG — Fri, 10 Feb 2017 16:18:21 GMT

I format the numeric values into Datetime7.

Re: SGPLOT Refline

DanH_sas — Fri, 10 Feb 2017 16:25:06 GMT

I needed to know the RAW format of the input date, not the final formatted value. The reason I ask is that it might make a difference on whether you should specify the refline value as '01jan2016'd (Rick) or '01jan2016:00:00:00'dt (ballardw). You want the refline value to match the other raw values used on the axis.

Re: SGPLOT Refline

Rick_SAS — Fri, 10 Feb 2017 16:36:40 GMT

To do what Dan asks, remove the format and use PROC PRINT to see the raw values:

/* replace the name of the dat set with YOUR name */
proc print data=sashelp.timedata(OBS=3);
format datetime;   /* <== put the name of YOUR variable here */
var datetime;        /* <== and here */
run;

Re: SGPLOT Refline

CEG — Fri, 10 Feb 2017 19:19:37 GMT

I'm sorry. Thanks for everyone's help.

The "numerics" I was talking about are 10 digits. That's why adding the 00:00:00 worked for at least the March date. The format was 7.

Here they are: 1751377219 1751420561 1751432207

Re: SGPLOT Refline

Rick_SAS — Fri, 10 Feb 2017 19:36:29 GMT

As we said earlier, use the literal datetime constants. See if this helps:

data a;
format x datetime20.;
do x = '01JUL2015:00:00:00'DT to '3DEC2016:00:00:00'DT by 1e6;
   y = 3 + sin(x/2e7);
   output;
end;

proc sgplot data=A;
series x=x y=y;
refline '08FEB2016:00:00:00'DT  '17MAR2016:00:00:00'DT / axis=x;
run;

Re: SGPLOT Refline

CEG — Fri, 10 Feb 2017 23:42:37 GMT

Thanks! I almost got it. This helped. Have to make a few adjustments.