Proc sgplot date issue

[ankan1987]

Hi,

Currently my data set is :

DT_APP	product category	apps
Jan2021	Cards	12363
Jan2021	Lending	6716
Feb2021	Cards	13217
Feb2021	Lending	7030
Mar2021	Cards	17400
Mar2021	Lending	8475
Apr2021	Cards	15488
Apr2021	Lending	7958
May2021	Cards	14316
May2021	Lending	8000
Jun2021	Cards	15559
Jun2021	Lending	8508
Jul2021	Cards	14255
Jul2021	Lending	9027
Aug2021	Cards	13901
Aug2021	Lending	12557
Sep2021	Cards	12515
Sep2021	Lending	11630
Oct2021	Cards	11295
Oct2021	Lending	10435
Nov2021	Cards	11416
Nov2021	Lending	8904
Dec2021	Cards	10424
Dec2021	Lending	8685
Jan2022	Cards	10836
Jan2022	Lending	8520

and after running sgplot with this code  :

proc sgplot data=prod_cat_WITH_DM_Apps_Graph1;
title justify=center "test" justify=center;
styleattrs datacontrastcolors=(blue green orange brown);
series x=dt_app y=apps / group=product_category lineattrs=(thickness=2 pattern=solid) legendlabel="Actual+Forecast";
yaxis grid label="apps";
xaxis label="Application Month" valuesformat=monyy.;

run;

I am getting output as :

Question: Why am I getting Mar22 in the horizontal axis when i don't have Mar22 in the dataset.

[PaigeMiller · Accepted solution]

The axis is chosen so that it extends past the highest value in the data and is consistently spaced (every 2 months). If you want different axes, you change the options in the XAXIS statement. In this case, you could probably use the MAX= option (and possibly other options as well).

[ankan1987]

Thanks for the tip! Setting max= latest date worked