topic Add refline for each year (date sequence) on sgplot in Graphics Programming

Add refline for each year (date sequence) on sgplot

mduarte — Fri, 18 Mar 2016 02:06:45 GMT

Hi - I am trying to add a refline at each year between a minimum and maximum date, with no success. Code to date is as follows:

%LET date1 = '01Jan2015';  
%LET date2 = '01Jan2018'; 

data test;
	date= &date1.d;
	do while(date <= &date2.d);
		y = rand('NORMAL', 0, 1);
		output;
		date=intnx('month', date, 1, 's');
	end;
	format date yymmdd10.;
  run;

proc print data=test(obs=5);
run;

proc sgplot data=test;
   series x=date y=y /markers;
   refline &date1.d / axis=x lineattrs=(color=red);
   *refline (&date1.d to &date2.d by month) / axis=x lineattrs=(color=red);
run;

Any help would be greatly appreciated.

Thanks.

Re: Add refline for each year (date sequence) on sgplot

Jay54 — Fri, 18 Mar 2016 02:43:54 GMT

You need to use a data set variable for the REFLINE statement. In the program below, I have computed a new one called Date2 in the data step to demonstrate the usage.

proc sgplot data=test;
series x=date y=y /markers;
refline date2/ axis=x lineattrs=(color=red);
run;

%LET date1 = '01Jan2015';
%LET date2 = '01Jan2018';

data test;
date= &date1.d;
do while(date <= &date2.d);
date2=.;
y = rand('NORMAL', 0, 1);
if date >= '01jan2016'd and date <= '01Jan2017'd then date2=date;
output;
date=intnx('month', date, 1, 's');
end;
format date date2 yymmdd10.;
run;

proc print data=test;
run;

proc sgplot data=test;
series x=date y=y /markers;
refline date2/ axis=x lineattrs=(color=red);
*refline (&date1.d to &date2.d by month) / axis=x lineattrs=(color=red);
run;

Re: Add refline for each year (date sequence) on sgplot

mduarte — Sun, 20 Mar 2016 21:47:29 GMT

Hi @Jay54. Thanks for the suggestion although I am not sure it will work in this case. Firstly, my data already exists (the data I created in the post was just to make the example reproducible) and it is not certain that a data point will exist on each year.