Data Set

Create a SAS Data Set containing Missing Values

Suppose you want to create a SAS data set with three variables: Name, Age, and Height. However, for some observations, you don’t know the Age and/or the Height. The missover option prevents SAS to look for the missing Age or Height on the next line. The next example shows how to use the missover option.

data work.ds;
	/* Define the Delimiter */
	infile datalines delimiter="," missover;
	
	/* Define the Variable Names and Types */
	input Name $ Age Height;
	
	/* Define the Content of the Data Set */
	datalines;
Maria, 30, 168 
Juan, 32,
Bob, 50, 185
John, ,
Kate, , 170
;
run;

Also, the official SAS documentation can be found here.

One thought on “Create a SAS Data Set containing Missing Values

Comments are closed.