topic Re: Json String Parse in SAS Programming

Json String Parse

bashique — Wed, 20 Apr 2022 12:07:07 GMT

How to parse json string which has more than 32767 characters in SAS?

sample of json string (Response key):

{"message"="1000 records found","status"="200","Respone"="[{\"name\":\"Jhon\",\"age\":22,\"class\":\"mca\"},{\"name\":\"Victor\",\"age\":22,\"class\":\"mca\"}]"}

above sample json has been parsed in python using json.loads() function can anyone suggest the alternative in sas

Re: Json String Parse

Ksharp — Wed, 20 Apr 2022 12:59:29 GMT

You can not use JSON engine of LIBNAME?

Re: Json String Parse

Ksharp — Wed, 20 Apr 2022 13:05:54 GMT

Also you could use data step to parse JSON file.

data have;
infile 'c:\temp\have.json' recfm=n dlm='{[,]}';
input have : $2000.;
run;

Re: Json String Parse

bashique — Thu, 21 Apr 2022 04:16:16 GMT

I have used JSON libname but the problem i am facing is when i have a large json string under "Response" key, only 32767 characters are getting stored in the variable and hence unable to parse

Re: Json String Parse

AllanBowe — Thu, 21 Apr 2022 08:51:55 GMT

The following macro will give you the tools to load a JSON file into a LUA table. Variables in LUA have no max-length (limited only by memory) so you can perform any processing you need there (using proc lua) before dropping back to SAS.

https://core.sasjs.io/ml__json_8sas_source.html

Re: Json String Parse

bashique — Thu, 21 Apr 2022 09:02:22 GMT

Hi AllanBowe, can you please specify the usage of LUA in ternm of sas code?

Re: Json String Parse

AllanBowe — Thu, 21 Apr 2022 10:24:18 GMT

Sure, here you go:

filename fref1 "/path/to/json.file";

/* compile the lua JSON module */
%ml_json()

/* create LUA code  */
data _null_;
  file "/path/to/file.lua";
  put '
    infile = io.open (sas.symget("fpath1"), "r")
    io.input(infile)
    local resp=json.decode(io.read())
    -- grab an element from the LUA table
    local logloc=resp["logLocation"]
    io.close(infile)
  ';
run;

/* execute LUA */
%inc "/path/to/file.lua";