How to read sas7bdat files? | Coursera Community

How to read sas7bdat files?

  • 18 March 2021
  • 0 replies
  • 19 views

Badge +1

Hello!

 

I’ve got a dataset in sas7bdat format. It contains English and Korean characters. If I open in some SAS Viewer, it’s ok.

But I want to modify this dataset, so I need to read it in some way.

 

  1. pandas_sas(). 
    But I read it with encoding=utf-8, I’ve got UnicodeDecodeError (in other encoding Korean characters will change on some strange things and I can’t translate them)
  2. sas7dbat library (https://pypi.org/project/sas7bdat/)
    But when I do  df = reader.to_data_frame() it changes all Korean characters to ‘?’ char
  3. Try to save from SAS View to .csv, but again this way changes Korean characters to ‘?’

 

So, how can I do this?

Thank you!


0 replies

Be the first to reply!

Reply