https://communities.sas.com/t5/SAS-Data-Management/Two-period-missing-values/m-p/304803#M8680 <P>Is your variable character or numeric? I'm guessing character and yes to eithe spaces or tabs.&nbsp;</P> <P>Look at the compress function - specifically the modifiers for all whitespace.&nbsp;</P> Fri, 14 Oct 2016 21:24:37 GMT Reeza 2016-10-14T21:24:37Z https://communities.sas.com/t5/SAS-Data-Management/Two-period-missing-values/m-p/304801#M8679 <P>For some reason, I have two missing values that are listed as periods. I want to combine them into one but I don't know how or why they are two rows for the exact same response. &nbsp;Are there hidden spaces I can't see? Picture attached.</P><BR /><IMG src="https://communities.sas.com/t5/image/serverpage/image-id/13060i3CE44B00A401EC4E/image-size/large?v=1.0&amp;px=600" border="0" alt="Capture.PNG" title="Capture.PNG" /> Fri, 14 Oct 2016 21:14:37 GMT https://communities.sas.com/t5/SAS-Data-Management/Two-period-missing-values/m-p/304801#M8679 samp 2016-10-14T21:14:37Z https://communities.sas.com/t5/SAS-Data-Management/Two-period-missing-values/m-p/304803#M8680 <P>Is your variable character or numeric? I'm guessing character and yes to eithe spaces or tabs.&nbsp;</P> <P>Look at the compress function - specifically the modifiers for all whitespace.&nbsp;</P> Fri, 14 Oct 2016 21:24:37 GMT https://communities.sas.com/t5/SAS-Data-Management/Two-period-missing-values/m-p/304803#M8680 Reeza 2016-10-14T21:24:37Z