Anyone can help for my captioned question? Thanks.
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 .
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.
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
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.