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
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.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.