## Proc means to determine missing value

Solved
Highlighted
Occasional Contributor
Posts: 10

# Proc means to determine missing value

Hi there,

New to SAS and have a quick question. I noticed when doing proc means that I am missing 2 observations. I am wondering how I can identify which observations are missing.

data eval.cohort;
set eval.finalcohort;
run;
/**calculate univariate analyses**/
proc means data=eval.cohort n nmiss mean median max min p10 p90;
var earliestvol;
run;

Accepted Solutions
Solution
‎03-14-2018 01:48 PM
Super User
Posts: 23,771

## Re: Proc means to determine missing value

``````data eval.cohort_missing;
set eval.cohort;
where missing(earliestvol);
run;``````

Filter them out manually and check them.

@kthartma wrote:

Hi there,

New to SAS and have a quick question. I noticed when doing proc means that I am missing 2 observations. I am wondering how I can identify which observations are missing.

data eval.cohort;
set eval.finalcohort;
run;
/**calculate univariate analyses**/
proc means data=eval.cohort n nmiss mean median max min p10 p90;
var earliestvol;
run;

All Replies
Solution
‎03-14-2018 01:48 PM
Super User
Posts: 23,771

## Re: Proc means to determine missing value

``````data eval.cohort_missing;
set eval.cohort;
where missing(earliestvol);
run;``````

Filter them out manually and check them.

@kthartma wrote:

Hi there,

New to SAS and have a quick question. I noticed when doing proc means that I am missing 2 observations. I am wondering how I can identify which observations are missing.

data eval.cohort;
set eval.finalcohort;
run;
/**calculate univariate analyses**/
proc means data=eval.cohort n nmiss mean median max min p10 p90;
var earliestvol;
run;

Occasional Contributor
Posts: 10

## Re: Proc means to determine missing value

Thanks so much.

Best,

Krystal

☑ This topic is solved.