SGPLOT: X axis values

[arpitsharma27]

Hello,

I have a two variables in a dataset.

One is YYYYMM. Ranging from 200601 to 200712.

Second is frequency of the variable.

When I run the code for individual year eg 200601 to 200612(or 200701 to 200712) I get the chart with title "Individual Year"

proc sgplot data=tst.numericfrequency;
series 	x=yyyymm 
	y=frequency ;
	xaxis values=(
		200601 200602 200603 200604 200605 200606 200607 200608 200609 200610 200611 200612 
/*		200701 200702 200703 200704 200705 200706 200707 200708 200709 200710 200711 200712 */
					) ;
where variable="numeric_variable" and variable_value=1;
title "Individual Year";
run;

But when I run the code for 2 years all together, I get the chart shown below with title "Combined Multiple Years."

There are no error/warnings in log.

Please let me know how can i fix it. I want the transition from 200612 to 200701 to be smooth and not that straight line.

Thanks

[ballardw · Accepted solution]

Convert those values to actual SAS dates. In a data step

sasdate = input(put(date,6.),yymmn6.);

Format the resulting date value as you would like it to appear either with a FORMAT statement or VALUESFORMAT on Xaxis.

Use the VALUES option of the XAXIS statement to indicate that you want monthly tick marks such as Values=( '01JAN2016'd to '01Dec2017'd by month) ;

Note the dates in the values statement have to be in 'ddMMMyyyy'd format as date literals (or the 2 digit year but I consider that sloppy), not the "formatted" value.