topic Re: PUT_statement help in SAS Programming

PUT_statement help

V_G_Kakani — Fri, 10 Oct 2014 15:31:56 GMT

I am using the following PUT statement. The missing value in columns RAIN, TAMX, TMIN and SRAD is -99.0. However, I need it to be -99. Any solution?

PUT LDATE Z5. RAIN 6.1 TMAX 6.1 TMIN 6.1 SRAD 6.1

Re: PUT_statement help

data_null__ — Fri, 10 Oct 2014 15:42:22 GMT

Something like this might do.

proc format; 
  value m99m(default=6) -99='   -99' other=[f6.1];
  run; 
data _null_; 
   input x;
   put x m99m.; 
   cards; 
9
-9
-99
89.88
;;;;
   run; 

Re: PUT_statement help

V_G_Kakani — Fri, 10 Oct 2014 22:29:16 GMT

Cheers. Works like a charm.