topic Reading JSON in SAS Programming

Reading JSON

rboire — Thu, 25 May 2017 22:10:41 GMT

Is there simple base SAS programming that read in the following JSON type data. See below example.

{

Tenure: 2 spend: 5

}

{

tenure:6 products:4 region:PQ spend:7

}

{

Credit score:100 region:ont tenure:7 country:can

}

{

Credit score:50 country:US

}

{

Tenure:5 region:US spend:100 creditscore:300

}

Re: Reading JSON

ballardw — Thu, 25 May 2017 22:37:56 GMT

Which version of SAS are you running?

Re: Reading JSON

Ksharp — Fri, 26 May 2017 13:30:40 GMT

I notice some "Credit score" have blanks in it, but the last one is not . which one is real world ?

Assuming there is no blank in it.

NOTE: if you have SAS9.4 M4 , best choice is libname + JSON engine.

data x;
 infile '/folders/myfolders/xxxx.json' lrecl=300000  dlm='}: ';
 input x : $200. @@;
run;
data want;;
 merge x x(firstobs=2 rename=(x=value));
 if x=:'{' then do;x=substr(x,2); id+1;end;
 if mod(_n_,2)=1;
run;
proc print noobs;run;