topic Re: Missing Values Statement in New SAS User

Missing Values Statement

learn2 — Fri, 14 Dec 2018 16:47:05 GMT

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!

Re: Missing Values Statement

Astounding — Fri, 14 Dec 2018 16:48:58 GMT

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.

Re: Missing Values Statement

Reeza — Fri, 14 Dec 2018 16:50:32 GMT

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;

Re: Missing Values Statement

novinosrin — Fri, 14 Dec 2018 16:56:44 GMT

@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;