topic Re: Exclude missing values from calculating mean of records for a variable in SAS Programming

Exclude missing values from calculating mean of records for a variable

jeremy4 — Fri, 03 May 2019 15:21:21 GMT

Hi,

I have the following code below but is there a line that I could include so that I would be able to get the mean of all of the records for the 'PROV' variable, excluding all of the missing values for that variable when calculating the mean? Would this be possible without deleting the record at the start as I would like to preserve all of the data in the dataset? Thanks.

data April_analysis;
set card_v_2019;
run;

proc means data=April_analysis mean SUM MAXDEC=2 ;
var PROV;
output out=PROVISION_BALANCE_MEAN;
run;

Re: Exclude missing values from calculating mean of records for a variable

Astounding — Fri, 03 May 2019 15:23:56 GMT

SAS dpes that automatically. If you were to ask for a few more statistics on the PROC MEANS line, you might be able to see that more clearly:

proc means data=April_analysis mean SUM N NMISS MAXDEC=2 ;

Re: Exclude missing values from calculating mean of records for a variable

noling — Fri, 03 May 2019 15:38:25 GMT

Ex these give the same result:

data temp;
	value = 1;
	output;
	value =2;
	output;
run;
proc means data=temp mean;
	var value;
run;
data temp2;
	value = 1;
	output;
	value =2;
	output;
	value=.;
	output;
run;
proc means data=temp2 mean;
	var value;
run;

Re: Exclude missing values from calculating mean of records for a variable

VDD — Fri, 03 May 2019 15:36:04 GMT

@noling you are doing mean on the same temp dataset

try this

data temp;
	value = 1;
	output;
	value =2;
	output;
run;
proc means data=temp mean;
	var value;
run;
data temp2;
	value = 1;
	output;
	
	value =4;
	output;
	value=.;
	output;
run;
proc means data=temp2 mean;
	var value;
run;

Re: Exclude missing values from calculating mean of records for a variable

noling — Fri, 03 May 2019 15:38:49 GMT

Thanks for catching my typo 🙂 Same result, but I edited my comment.