Reading a JSON file

Lopa2016 — Thu, 05 Jul 2018 14:37:32 GMT

Hi ,

I am trying to read a JSON file which looks like this:

{"ID":12825406,"Score":0,"IP":"MTExOTk5ODE5MA==","CREATED AT":1515519833,"COUNTRY CODE":"US","REGION":"north carolina"}

{"ID":12825464,"Score":10,"IP":"ODU4MDU1OTY=","CREATED AT":1515519960,"COUNTRY CODE":"IL","REGION":"tel aviv"}

{"ID":12825476,"Score":2,"IP":"MzIx,jc4MzgxMA==","CREATED AT":1515519974,"COUNTRY CODE":"BR","REGION":"sao paulo"}

{"ID":12825503,"Score":7,"IP":"MTIz,DE3MjM0OQ==","CREATED AT":1515520026,"COUNTRY CODE":"US","REGION":"massachusetts"}

{"ID":12825548,"Score":7,"IP":"MjE3,Tg3MDEw","CREATED AT":1515520125,"COUNTRY CODE":"US","REGION":"illinois"}

{"ID":12825588,"Score":8,"IP":"MTUw,jYw,jE1,g==","CREATED AT":1515520222,"COUNTRY CODE":"IE","REGION":"tipperary"}

{"ID":12825628,"Score":10,"IP":"MTY1ODgw,Dcy,A==","CREATED AT":1515520309,"COUNTRY CODE":"US","REGION":"illinois"}

{"ID":12825646,"Score":10,"IP":"MzE4,DI0MzA5Mg==","CREATED AT":1515520352,"COUNTRY CODE":"MX","REGION":"puebla"}

{"ID":12825711,"Score":8,"IP":"MTIz,jUz,Tcx,Q==","CREATED AT":1515520495,"COUNTRY CODE":"US","REGION":"oregon"}

{"ID":12825725,"Score":10,"IP":"MzAwOTU1,jg4Mg==","CREATED AT":1515520525,"COUNTRY CODE":"BR","REGION":"sao paulo"}

{"ID":12825742,"Score":7,"IP":"MTY3,zY0,DY3OA==","CREATED AT":1515520552,"COUNTRY CODE":"CA","REGION":"ontario"}

{"ID":12825746,"Score":10,"IP":"MzA5OTMzMDQxMg==","CREATED AT":1515520560,"COUNTRY CODE":"US","REGION":"virginia"}

Tried with scan & infile but not much luck.

Thanks in advance.

Re: Reading a JSON file

Cynthia_sas — Thu, 05 Jul 2018 14:49:17 GMT

Reeza — Thu, 05 Jul 2018 14:55:33 GMT

What version of SAS do you have?

proc product_status;run;