topic Re: How to import a JSON file in SAS? in SAS Programming

How to import a JSON file in SAS?

PatrickChan — Fri, 30 Sep 2016 02:32:13 GMT

Anyone can help for my captioned question? Thanks.

Re: How to import a JSON file in SAS?

Ksharp — Fri, 30 Sep 2016 03:19:27 GMT

1)PROC DS2  has a JSON package.

2)Data Step code.

I am not familiar with DS2. but if you could post that JSON file,
maybe I could write some data step code to get it .

Re: How to import a JSON file in SAS?

RW9 — Fri, 30 Sep 2016 08:49:51 GMT

Its pretty straight forward for datastep processing, read in the file as a text string,

on { start new id,

parameter=scan(string,1,"=")

if scan(string,2,"=") contains " then result_character=scan(string,2,"=")

else result_numeric=input(scan(string,2,"="),best.)

resulting dataset should then have each parameter and either test or number result which can then be transposed up.

Re: How to import a JSON file in SAS?

AhmedAl_Attar — Fri, 30 Sep 2016 14:22:03 GMT

Hi,

You can have a look at Chris Hemedinger's blog "Using SAS DS2 to parse JSON" and Mark Jordan's (SAS Jedi) blog "Jedi SAS Tricks: DS2 & APIs - GET the data you are looking for" for usage examples.

Hope this helps,

Ahmed

Re: How to import a JSON file in SAS?

rogerjdeangelis — Sun, 02 Oct 2016 00:30:26 GMT

see

https://listserv.uga.edu/cgi-bin/wa?A2=SAS-L;2e0080a6.1610a

for a related solution