topic How to remove the missing values in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-remove-the-missing-values/m-p/423070#M104020 <P>Hi , i have a data like below , i have to remove the missing cells , please suggest how to do so</P><P>&nbsp;</P><P>have ..&nbsp;</P><TABLE><TBODY><TR><TD>ID</TD><TD>shift_login</TD><TD>shift_logout</TD><TD>lunch_login</TD><TD>Lunch_logout</TD><TD>rest_login</TD><TD>Rest_logout</TD></TR><TR><TD>aaaaa</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>8:56</TD><TD>17:30</TD></TR><TR><TD>aaaaa</TD><TD>.</TD><TD>.</TD><TD>8:56</TD><TD>17:30</TD><TD>.</TD><TD>.</TD></TR><TR><TD>aaaaa</TD><TD>8:56</TD><TD>17:30</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>bbbbb</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>8:56</TD><TD>17:30</TD></TR><TR><TD>bbbbb</TD><TD>.</TD><TD>.</TD><TD>8:56</TD><TD>17:30</TD><TD>.</TD><TD>.</TD></TR><TR><TD>bbbbb</TD><TD>8:56</TD><TD>17:30</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>WANT...</P><TABLE><TBODY><TR><TD>ID</TD><TD>shift_login</TD><TD>shift_logout</TD><TD>lunch_login</TD><TD>Lunch_logout</TD><TD>rest_login</TD><TD>Rest_logout</TD></TR><TR><TD>aaaaa</TD><TD>8:56</TD><TD>17:30</TD><TD>8:56</TD><TD>17:30</TD><TD>8:56</TD><TD>17:30</TD></TR><TR><TD>bbbbb</TD><TD>8:56</TD><TD>17:30</TD><TD>8:56</TD><TD>17:30</TD><TD>8:56</TD><TD>17:30</TD></TR></TBODY></TABLE> Thu, 21 Dec 2017 11:52:09 GMT soham_sas 2017-12-21T11:52:09Z How to remove the missing values https://communities.sas.com/t5/SAS-Programming/How-to-remove-the-missing-values/m-p/423070#M104020 <P>Hi , i have a data like below , i have to remove the missing cells , please suggest how to do so</P><P>&nbsp;</P><P>have ..&nbsp;</P><TABLE><TBODY><TR><TD>ID</TD><TD>shift_login</TD><TD>shift_logout</TD><TD>lunch_login</TD><TD>Lunch_logout</TD><TD>rest_login</TD><TD>Rest_logout</TD></TR><TR><TD>aaaaa</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>8:56</TD><TD>17:30</TD></TR><TR><TD>aaaaa</TD><TD>.</TD><TD>.</TD><TD>8:56</TD><TD>17:30</TD><TD>.</TD><TD>.</TD></TR><TR><TD>aaaaa</TD><TD>8:56</TD><TD>17:30</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>bbbbb</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>8:56</TD><TD>17:30</TD></TR><TR><TD>bbbbb</TD><TD>.</TD><TD>.</TD><TD>8:56</TD><TD>17:30</TD><TD>.</TD><TD>.</TD></TR><TR><TD>bbbbb</TD><TD>8:56</TD><TD>17:30</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>WANT...</P><TABLE><TBODY><TR><TD>ID</TD><TD>shift_login</TD><TD>shift_logout</TD><TD>lunch_login</TD><TD>Lunch_logout</TD><TD>rest_login</TD><TD>Rest_logout</TD></TR><TR><TD>aaaaa</TD><TD>8:56</TD><TD>17:30</TD><TD>8:56</TD><TD>17:30</TD><TD>8:56</TD><TD>17:30</TD></TR><TR><TD>bbbbb</TD><TD>8:56</TD><TD>17:30</TD><TD>8:56</TD><TD>17:30</TD><TD>8:56</TD><TD>17:30</TD></TR></TBODY></TABLE> Thu, 21 Dec 2017 11:52:09 GMT https://communities.sas.com/t5/SAS-Programming/How-to-remove-the-missing-values/m-p/423070#M104020 soham_sas 2017-12-21T11:52:09Z Re: How to remove the missing values https://communities.sas.com/t5/SAS-Programming/How-to-remove-the-missing-values/m-p/423071#M104021 <P>Do like this</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data have; input ID$ (shift_login shift_logout lunch_login Lunch_logout rest_login Rest_logout)(:time5.); format shift_login shift_logout lunch_login Lunch_logout rest_login Rest_logout time5.; datalines; aaaaa . . . . 8:56 17:30 aaaaa . . 8:56 17:30 . . aaaaa 8:56 17:30 . . . . bbbbb . . . . 8:56 17:30 bbbbb . . 8:56 17:30 . . bbbbb 8:56 17:30 . . . . ; proc sort data=have; by ID; run; data want; update have(obs=0) have; by ID; run;</CODE></PRE> <P>&nbsp;</P> Thu, 21 Dec 2017 11:58:26 GMT https://communities.sas.com/t5/SAS-Programming/How-to-remove-the-missing-values/m-p/423071#M104021 PeterClemmensen 2017-12-21T11:58:26Z