SGPLOT Refline

[HabAM]

I need help pointing out what I am doing wrong. I am trying to put a ref line in my graph.

Here is my code:

proc sgplot data=graph;
vbar date/ group=group dataskin=pressed;
xaxis label='Onset date' values = ('01Jan2017'd to '30Jun2017'd by day) display=( novalues) ;
yaxis label='Number of Cases' values = (0 to 8 by 1) ;
format date date9.;
refline '01MAR2017'd / axis=x ;
run;

Here is my data format:

SAS Output

Alphabetic List of Variables and Attributes # Variable Type Len Format Informat Label 2 1

group	Char	27
date	Num	8	DATE9.	DATE9.	date

[DanH_sas · Accepted solution]

When putting a reference line on a discrete axis, you must use the formatted value. In your case, the REFLINE should look like this:

refline '01Mar2017' / axis=x ;

Hope this helps!

Dan

[HabAM]

Thank you it worked. I didn't realize it would be cases senstitve also.