I have used coalescec function
(coalescec(Name,' ' )) for this.But it is not working.KIndly help me on this.
How about:
if name = 'Null' then name=' ';
In the Expression column I have given this.
I cannot validate this expression.Its throwing error.
I am using SAS DI studio 4.21.
OK. Try this:
ifc(name='null',' ',name)
What do you mean?
In SAS character variables are stored as fixed length and are padded on the right with spaces. I am not sure there is any difference between the terms "null" and "empty string".
try function
tranwrd (name, "null" , " " )
I will present this and other things at NESUG this year
the following macro converts all nulls to zeros (that is what I needed) for eitehr a set of variables or for all numeric ones
you can easilly modify it to convert string 'null' to '' (blank) without typing multiple lines of code, even if here was a function this is better as you do not need to write 100 of lines to process 100's of variables
I attached a small text file, for some reason I could nto paste code from my sas editor
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.