*Copyright @ www.mycsg.in;

Numeric Functions to Analyze Variables in SAS

Function	Definition
N	The N function counts the number of numeric variables with non-missing values in a list of variables. This is useful for determining how many values are available for analysis.
NMISS	The NMISS function counts the number of numeric variables with missing values in a list of variables. This helps in identifying incomplete data.
SUM	The SUM function calculates the sum of non-missing numeric values in a list of variables. Missing values are ignored.
MEAN	The MEAN function calculates the average of non-missing numeric values in a list of variables. The denominator is the count of non-missing values.
MIN	The MIN function returns the smallest non-missing value from a list of numeric variables.
MAX	The MAX function returns the largest non-missing value from a list of numeric variables.

Create sample data

* Create a dataset with scores for three variables ;
data scores;
   infile datalines truncover;
   input score1 score2 score3;
datalines;
95 88 72
. 70 80
85 . .
. . .
50 60 70
;
run;

Examples for N Function

The N function is used to count the number of non-missing values in a list of variables.
In the example below, the variable `answered` shows how many values are non-missing for each observation.

* Count the number of variables with a non-missing value ;
data scores01;
    set scores;
    answered = n(score1, score2, score3);
run;

Examples for NMISS Function

The NMISS function counts the number of missing values in a list of variables.
In the example below, the variable `notanswered` shows how many values are missing for each observation.

* Count the number of variables with a missing value ;
data scores01;
    set scores;
    notanswered = nmiss(score1, score2, score3);
run;

Examples for SUM Function

The SUM function calculates the total of all non-missing values in a list of variables.
If all values are missing, the result is missing unless explicitly handled (e.g., by adding 0).

* Calculate the sum of values present in a list of variables ;
data scores01;
    set scores;
    sumscores = sum(score1, score2, score3);
run;

Examples for MEAN Function

The MEAN function calculates the average of all non-missing values in a list of variables.
If no values are non-missing, the result is missing unless explicitly handled.

* Calculate the average of values present in a list of variables ;
data scores01;
    set scores;
    meanscore = mean(score1, score2, score3);
run;

Examples for MIN Function

The MIN function returns the smallest non-missing value from a list of numeric variables.
If all values are missing, the result is missing unless explicitly handled.

* Find the minimum value from the values present in a list of variables ;
data scores01;
    set scores;
    minscore = min(score1, score2, score3);
run;

Examples for MAX Function

The MAX function returns the largest non-missing value from a list of numeric variables.
If all values are missing, the result is missing unless explicitly handled.

* Find the maximum value from the values present in a list of variables ;
data scores01;
    set scores;
    maxscore = max(score1, score2, score3);
run;

%convert_sas_to_html_format_002;