Write and run SAS programs in your web browser

Proc means to determine missing value

Accepted Solution Solved
Reply
Highlighted
Occasional Contributor
Posts: 10
Accepted Solution

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.

 

/**load data**/
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.

 

/**load data**/
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;


 

View solution in original post


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.

 

/**load data**/
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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 235 views
  • 2 likes
  • 2 in conversation