BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

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. 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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.

View solution in original post

2 REPLIES 2
Reeza
Super User

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.

ballardw
Super User

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 3153 views
  • 3 likes
  • 3 in conversation