Hi all, I'm having a little trouble exporting data to JSON. Here's the data I'm trying to export, in the structure that I'm trying to replicate: {
"Owner": [
{
"Cars": [
{
"Make":"Manufacturer 1"
},
{
"Make":"Manufacturer 2"
}
],
"Name":"SAS Man",
"Age":"20"
}
]
} I can read that into SAS with a JSON libname and copied into work no problem. This is the form of the SAS tables that I'm trying to export. The problem is trying to export it back into the same structure. Here's the code I have at the moment: proc json out=outjson pretty nosastags;
write open object; write values "Owner";
write open array; /* I know this is superfluous. I forgot to take it out for the MWE :S */
write open object; write values "Cars";
write open array;
export work.owner_cars(drop=ordinal_:);
write close;
write values "";
export work.owner(drop=ordinal_:);
write close;
write close;
write close;
run;
quit; The problem is that this ends up with Owner being an object containing the cars array (good), but with a separate dummy object containing the other data in the owner table (bad): {
"Owner": [
{
"Cars": [
{
"Make":"Manufacturer 1"
},
{
"Make":"Manufacturer 2"
}
],
"": {
"Name":"SAS Man",
"Age":"20"
}
}
]
} Is there any way I can nest the work.owner_cars data inside the owner table? Perhaps using the map or alldata that was created as part of the JSON libname?
... View more