BookmarkSubscribeRSS Feed
CurlerBob
Fluorite | Level 6
I have a .csv file that I'm trying to read in. The problem is that every other byte appears to be a NULL (char value = 00). The best solution I have is using the compress function to take the NULLs out. This isn't the first time my "data experts" have given me a file like this and I suspect that it is due to a decryption process that they use.

My question is this, is there a easier or slicker way of ignoring the bad bytes or am I doomed to repeat this exercise over and over again?
2 REPLIES 2
data_null__
Jade | Level 19
Sounds like you have a UNICODE file. Look at the ENCODING option on the INFILE or FILENAME statement.
CurlerBob
Fluorite | Level 6
Thanks. That worked great!

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1332 views
  • 0 likes
  • 2 in conversation