https://communities.sas.com/t5/SAS-Visual-Analytics/Replace-emty-char-variable-with-a-text-string/m-p/554463#M12354 <P>Hi,</P><P>Is it possible to replace an empty char variable with a specific string ? I know the replace function but I have to combine it with something else.&nbsp; Is there a kind of <STRONG><FONT color="#6a6a6a">COALESCE</FONT></STRONG>C in SAS VA? we are running 7.3.</P><P>&nbsp;</P><P>Thanks in advance.</P> Sat, 27 Apr 2019 09:42:34 GMT ANLYNG 2019-04-27T09:42:34Z https://communities.sas.com/t5/SAS-Visual-Analytics/Replace-emty-char-variable-with-a-text-string/m-p/554463#M12354 <P>Hi,</P><P>Is it possible to replace an empty char variable with a specific string ? I know the replace function but I have to combine it with something else.&nbsp; Is there a kind of <STRONG><FONT color="#6a6a6a">COALESCE</FONT></STRONG>C in SAS VA? we are running 7.3.</P><P>&nbsp;</P><P>Thanks in advance.</P> Sat, 27 Apr 2019 09:42:34 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Replace-emty-char-variable-with-a-text-string/m-p/554463#M12354 ANLYNG 2019-04-27T09:42:34Z https://communities.sas.com/t5/SAS-Visual-Analytics/Replace-emty-char-variable-with-a-text-string/m-p/554659#M12358 <P>Hi!</P> <P>&nbsp;</P> <P>IF missing([var]) RETURN 'Missing value!'</P> <P>ELSE [var]</P> <P>&nbsp;</P> <P>???</P> <P>&nbsp;</P> <P>//Fredrik</P> Mon, 29 Apr 2019 10:20:04 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Replace-emty-char-variable-with-a-text-string/m-p/554659#M12358 FredrikE 2019-04-29T10:20:04Z https://communities.sas.com/t5/SAS-Visual-Analytics/Replace-emty-char-variable-with-a-text-string/m-p/554953#M12362 <P>&nbsp;It works!!!! thanks</P> Tue, 30 Apr 2019 08:55:11 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Replace-emty-char-variable-with-a-text-string/m-p/554953#M12362 ANLYNG 2019-04-30T08:55:11Z