BookmarkSubscribeRSS Feed
Riteshdell
Quartz | Level 8

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

2 REPLIES 2
Reeza
Super User

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

LittlesasMaster
Obsidian | Level 7

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;

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1432 views
  • 0 likes
  • 3 in conversation