SGplot x axis ticks without lumping or losing data

Indescribled — Thu, 23 Sep 2021 05:43:25 GMT

I am trying to change my x axis ticks, but every time I do it either lumps the data into the new ticks or drops all data on years with no tick instead of just changing the labels.

What is the correct way to change axis ticks without combining or losing my data?

This is what I have:

filename test1234 url "https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2021/2021-09-21/nominees.csv";

proc import out=nominees datafile=test1234 dbms=csv replace; 
	guessingrows = max; 
run;

proc sgplot data=nominees;
	where year > 1000;
	vbar year / group = type stat=freq groupdisplay=stack;
	xaxis label = "Year"  values=(1960 to 2020 by 5);
run;

This is what I want the x axis and plot layout to look like (image from R, but I cannot do it in SAS to show is the issue):

Re: SGplot x axis ticks without lumping or losing data

Jagadishkatam — Thu, 23 Sep 2021 07:39:38 GMT

Please try to use the option type=linear in xaxis statement as below

proc sgplot data=nominees;
	where year > 1000;
	vbar year / group = type stat=freq groupdisplay=stack grouporder=descending;
	xaxis label = "Year"  type=linear values=(1960 to 2020 by 5);
run;

topic SGplot x axis ticks without lumping or losing data in SAS Programming

SGplot x axis ticks without lumping or losing data

Re: SGplot x axis ticks without lumping or losing data