Per request by the customer, the data set contains numeric nulls with a "." , but the customer wants it to be blank or null without the default numeric null of "." I've tried options missing = ' ', but that still has the numeric null with the period.
Is there another method ?
Thanks.
Options missing should work, can you show what you've tried that didn't work. There's something else that's going on then. Can you also confirm the data type of the variables you're trying to modify?
Are they all character/numeric or a mix?
@suncawy wrote:
Per request by the customer, the data set contains numeric nulls with a "." , but the customer wants it to be blank or null without the default numeric null of "." I've tried options missing = ' ', but that still has the numeric null with the period.
Is there another method ?
Thanks.
SAS represents missing numeric data as dots (or as uppercase letters for special missing values).
If you use options missing=' '; then SAS represents missing values as a space. Using the # character:
options missing='#';
data T; X=.; run;
Using this: OPTIONS MISSING='';
Its showing this:
You cannot change how missing values are stored in the dataset. But you can use the MISSING option to change what character is used to print missing values.
@suncawy , is it that you are delivering a SAS "dataset" with the extension "sas7bdat" to your customer?
The dataset isn't being sent to the customer.
From the dataset, its creating a flat file, basically a text file.
What process are you using to create the flat-file?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.