topic Re: treatment of missing values in proc sgplot in Graphics Programming

treatment of missing values in proc sgplot

ratika2 — Mon, 20 Apr 2020 07:43:43 GMT

proc sgplot data= sahelp.heart;
vbar cause_of_death(repalce missing="unknown") /
group= Status
groupdisplay=cluster
run;

'cause_of_dealth' column contains missing values which is not displayed as separate label. I need to replace missing values in cause_of_dealth by 'unknown' and then plot vertical bar graph.But this code is not working. How to replace missing by unknown in this code.

Re: treatment of missing values in proc sgplot

ed_sas_member — Mon, 20 Apr 2020 09:04:18 GMT

Hi @ratika2

In the SASHELP.HEART dataset, missing values for the DEATHCAUSE variable correspond to patients who are still alive. So I am not sure that it makes sense to consider their DEATHCAUSE as 'Unknown'.

If you still want to do that, I suggest that you write a DATA step first:

data heart;
	set sashelp.heart;
	if DeathCause="" then DeathCause="Unknown";
run;

proc sgplot data=heart;
	vbar DeathCause / group=Status groupdisplay=cluster;
run;

But as I said, that doesn't make sense to me .

The use of the MISSING option would be more realistic:

proc sgplot data=sashelp.heart;
	vbar DeathCause / group=Status groupdisplay=cluster missing;
run;

Best,

Re: treatment of missing values in proc sgplot

ratika2 — Mon, 20 Apr 2020 10:56:29 GMT

Hi,
thank you for the solution. I used heart data set just an example, for my different code.I have the I need to give label 'unknown' to the missing values in vbar. How to label them, in the code below?

proc sgplot data=sashelp.heart;
vbar DeathCause / group=Status groupdisplay=cluster missing;
run;

Thanks for the help 😀