Missing Values Statement

[learn2]

Hello! If I have a numeric variable (call it X) with a bunch of missing values in the dataset, what SAS command do I use to pull up only the observations with missing values? Is it the nmiss function? If so, how do I structure my command? Thanks!

[Astounding]

The WHERE statement can subset:

where var > . ;

It can be used in either a DATA step or a procedure.

Technically, if you have special missing values in your data, you would use:

where var > .Z ;

It sounds like that would not be an issue for you and you would be safe with the first statement.

[Reeza · Accepted solution]

Use the MISSING() function, since it works the same on character and numeric variables.
This would return all records missing x.

data want;
set have;
if missing(x);
run;

[novinosrin]

---

@learn2 wrote:

Hello! If I have a numeric variable (call it X) with a bunch of missing values in the dataset, what SAS command do I use to pull up only the observations with missing values? Is it the nmiss function? If so, how do I structure my command? Thanks!

---

Sounds like you need missing function 

where x=.;

/*or*/

where missing(x);

/*or*/

where x is missing;

/*or*/

where x is null;