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

Two period missing values

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.

Super User
Posts: 23,320

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
  • 2 in conversation