topic Re: Replace missing values to blanks in SAS Programming

Replace missing values to blanks

Alex91 — Sat, 24 Apr 2021 20:15:49 GMT

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!

Re: Replace missing values to blanks

Tom — Sat, 24 Apr 2021 20:47:20 GMT

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.

Re: Replace missing values to blanks

Alex91 — Sat, 24 Apr 2021 21:24:42 GMT

Ty Tom. Solved the issue using missing option.