SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Two period missing values

Reply
New User
Posts: 1

Two period missing values

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.  Are there hidden spaces I can't see? Picture attached.


Capture.PNG
Super User
Posts: 19,770

Re: Two period missing values

Is your variable character or numeric? I'm guessing character and yes to eithe spaces or tabs. 

Look at the compress function - specifically the modifiers for all whitespace. 

Ask a Question
Discussion stats
  • 1 reply
  • 209 views
  • 0 likes
  • 2 in conversation