DATA Step, Macro, Functions and more

Finding missing values from Variables Data

Reply
Contributor
Posts: 63

Finding missing values from Variables Data

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

Super User
Posts: 17,829

Re: Finding missing values from Variables Data

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

Contributor
Posts: 37

Re: Finding missing values from Variables Data

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;

Ask a Question
Discussion stats
  • 2 replies
  • 183 views
  • 0 likes
  • 3 in conversation