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.
What version of SAS do you have?
proc product_status;run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.