topic Re: how to get the not missing of variables in SAS Programming https://communities.sas.com/t5/SAS-Programming/how-to-get-the-not-missing-of-variables/m-p/695859#M212411 <P>Why should the two first obs of&nbsp;<STRONG>POTASSIU_NLOW_VA&nbsp;</STRONG>still be missing? Please provide a clear logic.</P> Mon, 02 Nov 2020 09:10:58 GMT PeterClemmensen 2020-11-02T09:10:58Z how to get the not missing of variables https://communities.sas.com/t5/SAS-Programming/how-to-get-the-not-missing-of-variables/m-p/695842#M212397 <P>Hi&nbsp;</P><P>i have a table of variables with values missing for some and not missing for some.how to get not missing of these values for all rows.</P><TABLE><TBODY><TR><TD><STRONG>subject&nbsp;</STRONG></TD><TD><STRONG>SODIUM_NLOW_VA</STRONG></TD><TD><STRONG>SODIUM_NHIGH_VA</STRONG></TD><TD><STRONG>POTASSIU_NLOW_VA</STRONG></TD><TD><STRONG>POTASSIU_NHIGH_VA</STRONG></TD><TD><STRONG>CARBDIOX_NHIGH_VA</STRONG></TD><TD><STRONG>CHLORIDE_NLOW_VA</STRONG></TD><TD><STRONG>CHLORIDE_NHIGH_VA</STRONG></TD><TD><STRONG>CARBDIOX_NLOW_VA&nbsp;&nbsp;</STRONG></TD></TR><TR><TD>1330</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>20</TD><TD>18</TD></TR><TR><TD>1330</TD><TD>50</TD><TD>30</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1330</TD><TD>50</TD><TD>30</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1330</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1330</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>20</TD><TD>15</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1233</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>80</TD><TD>63</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1233</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>80</TD><TD>63</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1233</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1233</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1233</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>53</TD><TD>23</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1233</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>53</TD><TD>23</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1233</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>thanks in advance</P> Mon, 02 Nov 2020 08:08:10 GMT https://communities.sas.com/t5/SAS-Programming/how-to-get-the-not-missing-of-variables/m-p/695842#M212397 Aayushi_17 2020-11-02T08:08:10Z Re: how to get the not missing of variables https://communities.sas.com/t5/SAS-Programming/how-to-get-the-not-missing-of-variables/m-p/695845#M212399 <P>What do you expect as result? One observation for each "subject" with all not missing values?</P> Mon, 02 Nov 2020 08:12:17 GMT https://communities.sas.com/t5/SAS-Programming/how-to-get-the-not-missing-of-variables/m-p/695845#M212399 andreas_lds 2020-11-02T08:12:17Z Re: how to get the not missing of variables https://communities.sas.com/t5/SAS-Programming/how-to-get-the-not-missing-of-variables/m-p/695851#M212405 <P>this how the output should look like</P><TABLE><TBODY><TR><TD><STRONG>subject</STRONG>&nbsp;</TD><TD><STRONG>SODIUM_NLOW_VA</STRONG></TD><TD><STRONG>SODIUM_NHIGH_VA</STRONG></TD><TD><STRONG>POTASSIU_NLOW_VA</STRONG></TD><TD><STRONG>POTASSIU_NHIGH_VA</STRONG></TD><TD><STRONG>CARBDIOX_NHIGH_VA</STRONG></TD><TD><STRONG>CHLORIDE_NLOW_VA</STRONG></TD><TD><STRONG>CHLORIDE_NHIGH_VA</STRONG></TD><TD><STRONG>CARBDIOX_NLOW_VA&nbsp;&nbsp;</STRONG></TD></TR><TR><TD>1330</TD><TD>50</TD><TD>30</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>20</TD><TD>18</TD></TR><TR><TD>1330</TD><TD>50</TD><TD>30</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>20</TD><TD>15</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1330</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>80</TD><TD>63</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1330</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>80</TD><TD>63</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1330</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>53</TD><TD>23</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>1233</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>53</TD><TD>23</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Mon, 02 Nov 2020 08:19:19 GMT https://communities.sas.com/t5/SAS-Programming/how-to-get-the-not-missing-of-variables/m-p/695851#M212405 Aayushi_17 2020-11-02T08:19:19Z Re: how to get the not missing of variables https://communities.sas.com/t5/SAS-Programming/how-to-get-the-not-missing-of-variables/m-p/695859#M212411 <P>Why should the two first obs of&nbsp;<STRONG>POTASSIU_NLOW_VA&nbsp;</STRONG>still be missing? Please provide a clear logic.</P> Mon, 02 Nov 2020 09:10:58 GMT https://communities.sas.com/t5/SAS-Programming/how-to-get-the-not-missing-of-variables/m-p/695859#M212411 PeterClemmensen 2020-11-02T09:10:58Z Re: how to get the not missing of variables https://communities.sas.com/t5/SAS-Programming/how-to-get-the-not-missing-of-variables/m-p/695862#M212414 jus keeping the not missing of each variable's...so the missing ones got deleted Mon, 02 Nov 2020 09:25:16 GMT https://communities.sas.com/t5/SAS-Programming/how-to-get-the-not-missing-of-variables/m-p/695862#M212414 Aayushi_17 2020-11-02T09:25:16Z