Hi I need help in how to fill a text missing field value with a value from a numeric field? I tried using case statement but that is not working. Below is my case statement. This is not working. case when text_field = ' ' then put (numeric_field,z9.) else text_field End as new_field I was adviced to use the coalesce function and that is not working. I have tried proc sql and data step not working. My understanding is that when using coalesce function field types have to be the same. Any help will be greatly appreciated. Thank you.
... View more