Replace missing values to blanks

[Alex91]

Hello,

I have a character date column (yymmdd10.) in the sas dataset. It has missing values. I have to replace all missing values with empty value ' '.

Trying to make it through proc sql with update statement but nothing happens, column still has missing values

proc sql;

update work.char_atg

set

birthday = ''

where missing(birthday)

;

quit;

run;

Any help would appreciate!

[Tom · Accepted solution]

This request does not make much sense. 

If the variable is character then "missing" values are already blanks.  SAS uses fixed length character variables and pads all values with spaces to defined length.

If the variable is numeric (that is an actual number of days since 1/1/1960) then you can cannot store a character string like a space into the variable.   You can change the MISSING option to change how the numeric missing values print. 

[Alex91]

Ty Tom. Solved the issue using missing option.