Missing values.

saslovethemost — Tue, 02 Jan 2018 16:07:32 GMT

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.

Re: Missing values.

Reeza — Tue, 02 Jan 2018 16:11:25 GMT

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.

Re: Missing values.

ballardw — Tue, 02 Jan 2018 16:35:44 GMT

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.

topic Re: Missing values. in SAS Programming

Missing values.

Re: Missing values.

Re: Missing values.