topic Formatting datalabels without overriding value label formats in SGPLOT in New SAS User

Formatting datalabels without overriding value label formats in SGPLOT

dbcrow — Mon, 29 Oct 2018 19:05:47 GMT

Hi, fellow SAS users-

First-time poster, here, so please give tips/observations on how to improve posts.

I'm trying to create a dot plot in which the dots have data labels to two decimal places and the x-axis value labels follow a format that I've predefined. I can't seem to get both at the same time, however.

I have some lines of code that assign the following labels to the values 0-3 of the variable "assess":

PROC FORMAT;
	value assess 0 = "Strongly Disagree" 1 = "Disagree" 2 = "Agree" 3 = "Strongly Agree";
RUN;

Later in the code, I create a data set with the variable "assess", limiting it to two decimals.

DATA coal_long2;
	MERGE coal_long formerge;
	BY Coalition;
	format assess d4.2;
RUN;

When I create the dot plot using this code:

/*Dot Chart*/
/*Figure 1:  Mean Self-Assessment by Coalition*/
ods listing style=listing;
ods listing gpath="H:\Coalitions\";
ods graphics on / imagename="figure1a";
ods graphics / width=8in height=7in;
PROC SGPLOT data=coal_long2;
	format Coalition Coalition. assess assess.;
	dot Coalition / response=assess stat=mean datalabel limitstat=clm; 
	title "Figure 1. Mean Self-Assessment (By Coalition)";
RUN;
ods graphics off;

I get this chart, with value labels on the x-axis, but data labels to many decimal points:

On the other hand, when I remove the argument that applies the value labels ("assess assess."), with this code:

/*Dot Chart*/
/*Figure 1:  Mean Self-Assessment by Coalition*/
ods listing style=listing;
ods listing gpath="H:\Coalitions\";
ods graphics on / imagename="figure1a";
ods graphics / width=8in height=7in;
PROC SGPLOT data=coal_long2;
	format Coalition Coalition.;
	dot Coalition / response=assess stat=mean datalabel limitstat=clm; 
	title "Figure 1. Mean Self-Assessment (By Coalition)";
RUN;
ods graphics off;

I get data labels to two decimals, but no value labels.

I'm clearly not understanding SAS's formatting procedures; there's something I'm missing "upstream," but I can't figure out what it is. Could someone throw me a bone, here?

Thanks,

David

Re: Formatting datalabels without overriding value label formats in SGPLOT

Reeza — Mon, 29 Oct 2018 20:11:56 GMT

You can assign a different variable as the datalabel, so use two variables here, that are essentially identical.

Format the one for the datalabel using 8.2 and then format the one with the format required for the axis.

DATA coal_long2;
	MERGE coal_long formerge;
	BY Coalition;

dl = assess;

format assess assess.;
format dl F8.2;

RUN;	


/*Dot Chart*/
/*Figure 1:  Mean Self-Assessment by Coalition*/
ods listing style=listing;
ods listing gpath="H:\Coalitions\";
ods graphics on / imagename="figure1a";
ods graphics / width=8in height=7in;
PROC SGPLOT data=coal_long2;
	format Coalition Coalition. assess assess.;
	dot Coalition / response=assess stat=mean datalabel=dl limitstat=clm; 
	title "Figure 1. Mean Self-Assessment (By Coalition)";
RUN;
ods graphics off;

@dbcrow wrote:

Hi, fellow SAS users-

First-time poster, here, so please give tips/observations on how to improve posts.

I'm trying to create a dot plot in which the dots have data labels to two decimal places and the x-axis value labels follow a format that I've predefined. I can't seem to get both at the same time, however.

I have some lines of code that assign the following labels to the values 0-3 of the variable "assess":
PROC FORMAT;
	value assess 0 = "Strongly Disagree" 1 = "Disagree" 2 = "Agree" 3 = "Strongly Agree";
RUN;
Later in the code, I create a data set with the variable "assess", limiting it to two decimals.
DATA coal_long2;
	MERGE coal_long formerge;
	BY Coalition;
	format assess d4.2;
RUN;	
When I create the dot plot using this code:
/*Dot Chart*/
/*Figure 1:  Mean Self-Assessment by Coalition*/
ods listing style=listing;
ods listing gpath="H:\Coalitions\";
ods graphics on / imagename="figure1a";
ods graphics / width=8in height=7in;
PROC SGPLOT data=coal_long2;
	format Coalition Coalition. assess assess.;
	dot Coalition / response=assess stat=mean datalabel limitstat=clm; 
	title "Figure 1. Mean Self-Assessment (By Coalition)";
RUN;
ods graphics off;
I get this chart, with value labels on the x-axis, but data labels to many decimal points:

On the other hand, when I remove the argument that applies the value labels ("assess assess."), with this code:
/*Dot Chart*/
/*Figure 1:  Mean Self-Assessment by Coalition*/
ods listing style=listing;
ods listing gpath="H:\Coalitions\";
ods graphics on / imagename="figure1a";
ods graphics / width=8in height=7in;
PROC SGPLOT data=coal_long2;
	format Coalition Coalition.;
	dot Coalition / response=assess stat=mean datalabel limitstat=clm; 
	title "Figure 1. Mean Self-Assessment (By Coalition)";
RUN;
ods graphics off;
I get data labels to two decimals, but no value labels.

I'm clearly not understanding SAS's formatting procedures; there's something I'm missing "upstream," but I can't figure out what it is. Could someone throw me a bone, here?

Thanks,

David

Re: Formatting datalabels without overriding value label formats in SGPLOT

dbcrow — Tue, 30 Oct 2018 22:24:27 GMT

Many thanks, Reeza. It took a little bit of doing, but I got some code that worked!

Best,

David