Reading a JSON file

Reply
Contributor
Posts: 54

Reading a JSON file

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.

SAS Super FREQ
Posts: 9,368

Re: Reading a JSON file

Super User
Posts: 23,705

Re: Reading a JSON file

What version of SAS do you have?

 

proc product_status;run;
Ask a Question
Discussion stats
  • 2 replies
  • 43 views
  • 0 likes
  • 3 in conversation