DATA Step, Macro, Functions and more

Reading JSON

Reply
Occasional Contributor
Posts: 15

Reading JSON

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 regionSmiley TongueQ spend:7

}

{

Credit score:100 regionSmiley Surprisednt tenure:7 country:can

}

{

Credit score:50 country:US

}

{

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

}

   

Super User
Posts: 10,516

Re: Reading JSON

Which version of SAS are you running?

Super User
Posts: 9,682

Re: Reading JSON

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;

x.png

Ask a Question
Discussion stats
  • 2 replies
  • 124 views
  • 0 likes
  • 3 in conversation