DATA Step, Macro, Functions and more

How to read Nested JSON file into SAS?

Reply
Regular Learner
Posts: 1

How to read Nested JSON file into SAS?

Hi All,

 

I am trying to read JSON file using LIBNAME engine, after reading one complete Observation SAS is throwing a ERROR saying

Illegal Character encounter. 

 

Please let me know how to overcome this ERROR.

 

Thanks,

Krishna ReddyERROR_JSON1.jpg

 

Super User
Posts: 13,941

Re: How to read Nested JSON file into SAS?

Posted in reply to bvkreddy053

Open the file in a text editor and look around line 331 in the file for something that looks out of place.

 

There may be a chance that your current encoding (language/ character set) isn't compatible with the file contents such as finding Chinese characters in the data when not expected.

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