BookmarkSubscribeRSS Feed
samp
Calcite | Level 5

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
1 REPLY 1
Reeza
Super User

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. 

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 884 views
  • 0 likes
  • 2 in conversation