Hello all,
I am having issue with missing values in the report. The report looks like below.
ADJUSTED
CASH ENDING ENDING
SERVICER BALANCE BALANCE
NUMBER DIFFERENCE END BAL (=) (+)
XXXXXX -0.00 271402.27 -271402.27 1420485.32
XXXXXX 0.00 0.00 0.00 19509.07
XXXXXX 0.00 . 0.00 3402.88
XXXXXX 0.00 . 0.00 0.00
XXXXXX 0.00 . 0.00 1941.35
XXXXXX 0.00 . 0.00 4115.95
XXXXXX 0.00 0.00 0.00 816.53
-------- --------------- ------------- ------------- --------------- ---
ACTCODE -0.00 271402.27 -271402.27 1450271.10
INTEREST REO INTEREST REINST FRCLS INT 3RD PRTY P&I
COLLECTED ADVANCED INTEREST ADVANCED SALE FROM LL
(-) (+) (-) (+) (-) (+)
593450.96 . . . . .
9227.82 . . . . .
1885.66 . . . . .
0.00 . . . . .
733.07 . . . . .
2496.49 . . . . .
481.25 . . . . .
------------- ------------ ------------- --------- ----------- ------------ -
608275.25 0.00 0.00 0.00 0.00 0.00
I want to replace the missing value '.' with 0.00, the input datasets has missing values, they are calculated in the program and shown on the report. Is there a way to efficiently do in SAS. I really appreciate your help.
Thanks in advance.
Neal.
You can try
option missing='0';
But you should show your code, then we can make a recommendation. I'm assuming you're using PROC REPORT? Or a Data Step?
Other options depend on your current data structure, and obviously the easiest fix is to make the values 0 ahead of time and not change the reporting code.
You can try
option missing='0';
But you should show your code, then we can make a recommendation. I'm assuming you're using PROC REPORT? Or a Data Step?
Other options depend on your current data structure, and obviously the easiest fix is to make the values 0 ahead of time and not change the reporting code.
Another option is to use create a format that displays missing as 0.00 and other values as desired but we'd need to see more examples to suggest a specific solution. One example could be:
proc format library=work; value mymiss . = '0.00' other =[F11.2] ; run;
And use the MYMISS. format for your report items.
The missing option will only display a single character.
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.