BookmarkSubscribeRSS Feed
bvkreddy053
Calcite | Level 5

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.jpgERROR_JSON1.jpg

 

1 REPLY 1
ballardw
Super User

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.

sas-innovate-wordmark-gradient-background 3.pngSAS Innovate

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 1 reply
  • 2152 views
  • 0 likes
  • 2 in conversation