06-27-2013 05:19 AM
In the Expression column I have given this.
I cannot validate this expression.Its throwing error.
I am using SAS DI studio 4.21.
06-27-2013 08:45 AM
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".
06-27-2013 11:03 AM
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