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

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

1 ACCEPTED SOLUTION

Accepted Solutions
data_null__
Jade | Level 19

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;

View solution in original post

2 REPLIES 2
data_null__
Jade | Level 19

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;
V_G_Kakani
Calcite | Level 5

Cheers. Works like a charm.

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 832 views
  • 0 likes
  • 2 in conversation