Reading JSON

[rboire]

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

}

[ballardw]

Which version of SAS are you running?

[Ksharp]

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;