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.
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?
no my source is a fixed width file
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.
data want;
input id 3. sex $char1. age 3. ;
cards;
001M010
002F012
003.011
004 013
;;;
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.
the source is a fixed width file.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.