https://communities.sas.com/t5/New-SAS-User/extract-non-missing-value/m-p/575885#M12955 <P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>Hi Team,</P><P>&nbsp;</P><P>Can you please tell me how to extract non missing value (Expected_data) data by using single statement.</P><P>&nbsp;</P><P>Below is the example I am expecting <STRONG>expected_data</STRONG> column</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="que1.PNG" style="width: 574px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/31237iFF328AF0BA0BCD08/image-size/large?v=v2&amp;px=999" role="button" title="que1.PNG" alt="que1.PNG" /></span></P><P><BR />Please let me know if you need any further clarification form my side.&nbsp;&nbsp;</P> Tue, 23 Jul 2019 16:39:56 GMT bhanuprakash 2019-07-23T16:39:56Z https://communities.sas.com/t5/New-SAS-User/extract-non-missing-value/m-p/575885#M12955 <P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>Hi Team,</P><P>&nbsp;</P><P>Can you please tell me how to extract non missing value (Expected_data) data by using single statement.</P><P>&nbsp;</P><P>Below is the example I am expecting <STRONG>expected_data</STRONG> column</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="que1.PNG" style="width: 574px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/31237iFF328AF0BA0BCD08/image-size/large?v=v2&amp;px=999" role="button" title="que1.PNG" alt="que1.PNG" /></span></P><P><BR />Please let me know if you need any further clarification form my side.&nbsp;&nbsp;</P> Tue, 23 Jul 2019 16:39:56 GMT https://communities.sas.com/t5/New-SAS-User/extract-non-missing-value/m-p/575885#M12955 bhanuprakash 2019-07-23T16:39:56Z https://communities.sas.com/t5/New-SAS-User/extract-non-missing-value/m-p/575887#M12956 <PRE><CODE class=" language-sas">want=coalescec(of race_a--race_e);</CODE></PRE> Tue, 23 Jul 2019 16:41:10 GMT https://communities.sas.com/t5/New-SAS-User/extract-non-missing-value/m-p/575887#M12956 novinosrin 2019-07-23T16:41:10Z https://communities.sas.com/t5/New-SAS-User/extract-non-missing-value/m-p/575894#M12957 Thank you so much for the quick response. Tue, 23 Jul 2019 16:58:49 GMT https://communities.sas.com/t5/New-SAS-User/extract-non-missing-value/m-p/575894#M12957 bhanuprakash 2019-07-23T16:58:49Z