topic Re: Finding missing values from Variables Data in SAS Programming

Finding missing values from Variables Data

Riteshdell — Sun, 26 Jun 2016 13:45:59 GMT

Hello All,

I want to Know , how to find missing values in Varible data of any Data set.

Below is an example OF DATASET

ID Name Gender

101 RaM mALE

. tONY mALE

103 . fEMALE

Re: Finding missing values from Variables Data

Reeza — Sun, 26 Jun 2016 14:29:44 GMT

Ok. So what do you want as an output?

Missing values for character variables are spaces and a period for numeric. You can also look into the missing function.

The docs are pretty clear on missing values.

http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a002316433.htm

Re: Finding missing values from Variables Data

LittlesasMaster — Mon, 27 Jun 2016 03:49:31 GMT

Try this...

data want;
input id name $ gender $;
if missing(id) then Miss_id="Yes Id missing";
if missing(name) then Miss_name="Yes name missing";
if missing(gender) then Miss_gender="Yes gender missing";

cards;
101 ram male
. tony male
103 . female
;
run;