Handling Missing Values with the SUM Function

This program illustrates a key behavior of the SUM function in SAS^©: unlike simple arithmetic addition, the SUM function ignores missing values (treats them as 0) when calculating the total, ensuring that a numeric result is returned as long as at least one argument is non-missing.

Data Analysis

Type : CREATION_INTERNE

The 'cholesterol' data is generated directly in the code using the DATALINES statement.

1 Code Block

DATA STEP Data

Explanation :
Creation of a table named 'cholesterol'. The 'Total1' variable is calculated by adding 'Ldl', 'Hdl', and 'Vldl'. Observation 2 contains a missing value for 'Vldl', demonstrating that 'Total1' will still be calculated (205) thanks to the SUM function.

Copied!

1	DATA cholesterol;
2	INPUT ID Ldl Hdl Vldl;
3	Total1 = SUM(Ldl, Hdl, Vldl);
4	DATALINES;
5	1 160 50 20
6	2 150 55 .
7	3 120 40 30
8	4 140 50 25
9	;
10	RUN;

This material is provided "as is" by We Are Cas. There are no warranties, expressed or implied, as to merchantability or fitness for a particular purpose regarding the materials or code contained herein. We Are Cas is not responsible for errors in this material as it now exists or will exist, nor does We Are Cas provide technical support for it.

Retour à la liste

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. WeAreCAS is an independent community site and is not affiliated with SAS Institute Inc.