*Copyright @ www.statschoice.com;

/********************************************************************************

Count the number of variables with a non-missing value - n function

********************************************************************************/

data scores01;
      set scores;
      answered=n(score1,score2,score3);
  run;

/********************************************************************************

Count the number of variables with a missing value - nmiss function

********************************************************************************/

data scores01;
      set scores;
      notanswered=nmiss(score1,score2,score3);
  run;

/********************************************************************************

Find the sum of values present of a list of variables - sum function

********************************************************************************/

data scores01;
      set scores;
      sumscores=sum(score1,score2,score3);
  run;

/********************************************************************************

Find the sum of values present of a list of variables - sum function
Only at least one question is answered

********************************************************************************/

data scores01;
      set scores;
      if n(score1,score2,score3) ge 1 then sumscores=sum(score1,score2,score3);
  run;

/********************************************************************************

Find the average of values present of a list of variables - mean function
Denominator should be the number of variables with non-missing values

********************************************************************************/

data scores01;
      set scores;
      meanscore=mean(score1,score2,score3);
  run;

/********************************************************************************

Find the average of values present of a list of variables - mean function
Denominator should be the number of variables with non-missing values
Mean should be calculated only when at least one variable has a non-missing value

********************************************************************************/

data scores01;
      set scores;
      if n(score1,score2,score3) ge 1 then meanscore=mean(score1,score2,score3);
  run;

/********************************************************************************

Find the sum of values present of a list of variables - sum function
If all variables have a missing value then set the sum to 0.

********************************************************************************/

data scores01;
      set scores;
      sumscores=sum(0,score1,score2,score3);
  run;

/********************************************************************************

Find the minimum value from the values present in a list of variables - min function

********************************************************************************/

data scores01;
      set scores;
      minscore=min(score1,score2,score3);
   
  run;

/********************************************************************************

Find the minimum value from the values present in a list of variables - min function
If all variables have a missing value then set the minimum value to 0.

********************************************************************************/

data scores01;
      set scores;
      if n(score1,score2,score3) ge 1 then minscore=min(score1,score2,score3);
      else minscore=0;
  run;

/********************************************************************************

Find the maximum value from the values present in a list of variables - max function

********************************************************************************/

data scores01;
      set scores;
      maxscore=max(score1,score2,score3);
  run;

/********************************************************************************

Find the maximum value from the values present in a list of variables - max function
If all variables have a missing value then set the maximum value to 0.

********************************************************************************/

data scores01;
      set scores;
      maxscore=max(0,score1,score2,score3);
  run;

/********************************************************************************

Find the subjects whose height is reported in integers - int function

********************************************************************************/

data hw01;
      set hw;
      if height=int(height);
  run;

/********************************************************************************

Find the subjects whose height is NOT reported in integers - int function

********************************************************************************/

data hw01;
      set hw;
      if height ne int(height);
  run;

/********************************************************************************

Extract the integer portion of height value of subject - int function

********************************************************************************/

data hw01;
      set hw;
      height2=int(height);
  run;

/********************************************************************************

Round the weight value to nearest integer value - round function

********************************************************************************/

data hw01;
      set hw;
      weight2=round(weight,1);
  run;

/********************************************************************************

Round the weight value to nearest one decimal value - round function

********************************************************************************/

data hw01;
      set hw;
      weight2=round(weight,0.1);
  run;

/********************************************************************************

Round the weight value to nearest two decimal value - round function

********************************************************************************/

data hw01;
      set hw;
      weight2=round(weight,0.01);
  run;

/********************************************************************************

Round the weight value to next highest integer - ceil function

********************************************************************************/

data hw01;
      set hw;
      weight2=ceil(weight);
  run;

/********************************************************************************

Round the weight value to next lowest integer - floor function

********************************************************************************/

data hw01;
      set hw;
      weight2=floor(weight);
  run;

*Copyright @ www.statschoice.com;

Count the number of variables with a non-missing value - n function

Count the number of variables with a missing value - nmiss function

Find the sum of values present of a list of variables - sum function

Find the sum of values present of a list of variables - sum function Only at least one question is answered

Find the average of values present of a list of variables - mean function Denominator should be the number of variables with non-missing values

Find the average of values present of a list of variables - mean function Denominator should be the number of variables with non-missing values Mean should be calculated only when at least one variable has a non-missing value

Find the sum of values present of a list of variables - sum function If all variables have a missing value then set the sum to 0.

Find the minimum value from the values present in a list of variables - min function

Find the minimum value from the values present in a list of variables - min function If all variables have a missing value then set the minimum value to 0.

Find the maximum value from the values present in a list of variables - max function

Find the maximum value from the values present in a list of variables - max function If all variables have a missing value then set the maximum value to 0.

Find the subjects whose height is reported in integers - int function

Find the subjects whose height is NOT reported in integers - int function

Extract the integer portion of height value of subject - int function

Round the weight value to nearest integer value - round function

Round the weight value to nearest one decimal value - round function

Round the weight value to nearest two decimal value - round function

Round the weight value to next highest integer - ceil function

Round the weight value to next lowest integer - floor function

Find the sum of values present of a list of variables - sum function
Only at least one question is answered

Find the average of values present of a list of variables - mean function
Denominator should be the number of variables with non-missing values

Find the average of values present of a list of variables - mean function
Denominator should be the number of variables with non-missing values
Mean should be calculated only when at least one variable has a non-missing value

Find the sum of values present of a list of variables - sum function
If all variables have a missing value then set the sum to 0.

Find the minimum value from the values present in a list of variables - min function
If all variables have a missing value then set the minimum value to 0.

Find the maximum value from the values present in a list of variables - max function
If all variables have a missing value then set the maximum value to 0.