06-25-2015 11:14 AM
SAS treats Blank space as missing values . In order to distinguish between blank space character and null value while reading from job how to manage it.
06-25-2015 11:18 AM
You said it yourself, SAS treats blank as missing/null, so basically, you can't (since there is no difference).
If your source data resides in a DBMS that distinguish between NULL and blank, you coud do a SQL pass-thru query where you test this in the source.
What's your issue?
06-25-2015 01:03 PM
So if you have a fixed width file how would it be possible to have an empty field? To make it fixed width there has to be some character in those columns of the file.
If you use $CHAR informat instead of the default $ informat for character variables then periods in the source file will not be translated to blanks.
input id 3. sex $char1. age 3. ;
06-25-2015 11:22 AM
File format is important here and how the data set is read. When using list input blanks are delimiters and options control what may or may not be missing.
Is your data delimited or fixed column?
How are you reading it?
It may be helpful to provide some example rows of data with the issue you are having.
Some common options that address bits of this kind of issue are DLM (or Delimiter) , DSD, RECFM plus options on Input statements.