I am trying to read a JSON file with 30 arrays. Here's the code:
filename in "Source.json";
filename map 'WorkingMap.Map';
libname in json map=Map automap=reuse;
libname j json "Source.json" map=Map;
By default this syntax creates a separate table for each array. For the example below, the code above creates Proc1-Proc4 columns in a table PROC with Ordinal_Root link to the main ROOT dataset.
"proc": [
2800,
2980,
4090,
4170
],
I have to merge multiple files into one for my purposes and also aggregate multiple columns into one. On top of that, I am processing dozens of JSONS that need to be stacked to there's a ton of re-merging going on. Is there an option or a mapping method/trick to read arrays as simple text strings? For the PROC example above, rather than a dedicated separate table with multiple columns for each value of the array, I would like a single column that contains them all in one cell just like in the JSON:
[ 2800, 2980, 4090, 4170 ]
Need help!!!
... View more
![SASGF 2020 [Virtual] Attendee](/html/@A53A708409112314CE528E074D4C8C1F/badge_icons/badge_sasgf20_attendee.png "SASGF 2020 [Virtual] Attendee"){kind=icon}
