https://communities.sas.com/t5/SAS-Programming/How-to-replace-missing-values-from-other-variable/m-p/849726#M335897 <P>Hi Sas Users,</P><P>I need a quick advice.</P><P>How should I use the SAS code to replace the value of gender2 to gender variable if the information in gender variable is missing.</P><P>Thank you!</P><PRE>data have; format id $1. gender $1. gender2 $1.; input @1 ID @ 3 GENDER @ 6 GENDER2; DATALINES; 1 f . 2 . m 3 m . 4 . f ; run;</PRE> Wed, 14 Dec 2022 19:59:10 GMT chimei0403 2022-12-14T19:59:10Z https://communities.sas.com/t5/SAS-Programming/How-to-replace-missing-values-from-other-variable/m-p/849726#M335897 <P>Hi Sas Users,</P><P>I need a quick advice.</P><P>How should I use the SAS code to replace the value of gender2 to gender variable if the information in gender variable is missing.</P><P>Thank you!</P><PRE>data have; format id $1. gender $1. gender2 $1.; input @1 ID @ 3 GENDER @ 6 GENDER2; DATALINES; 1 f . 2 . m 3 m . 4 . f ; run;</PRE> Wed, 14 Dec 2022 19:59:10 GMT https://communities.sas.com/t5/SAS-Programming/How-to-replace-missing-values-from-other-variable/m-p/849726#M335897 chimei0403 2022-12-14T19:59:10Z https://communities.sas.com/t5/SAS-Programming/How-to-replace-missing-values-from-other-variable/m-p/849727#M335898 <PRE><CODE class=" language-sas">data want; set have; gender=coalescec(gender,gender2); run;</CODE></PRE> Wed, 14 Dec 2022 20:03:16 GMT https://communities.sas.com/t5/SAS-Programming/How-to-replace-missing-values-from-other-variable/m-p/849727#M335898 PaigeMiller 2022-12-14T20:03:16Z https://communities.sas.com/t5/SAS-Programming/How-to-replace-missing-values-from-other-variable/m-p/849730#M335901 Thank you soooo much!! Wed, 14 Dec 2022 20:02:54 GMT https://communities.sas.com/t5/SAS-Programming/How-to-replace-missing-values-from-other-variable/m-p/849730#M335901 chimei0403 2022-12-14T20:02:54Z