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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.