Hello Team,
am reading data from Json file , where its contents are dynamic as shown in below format
the first record has all attributes , where as second record has only few attributes.
[
{
"id": 0,
"name": "Nora",
"city": "New Orleans",
"age": 55,
"friends": [
{
"name": "Emma",
"hobbies": [ "Calligraphy", "Television", "Music" ]
},
{
"name": "Lucas",
"hobbies": [ "Yoga", "Playing Cards" ]
}
]
},
{
"id": 1,
"name": "Mia",
},
]
libname APIJSON JSON fileref=jsonout;
proc datasets lib=APIJSON; quit;
i would like to concatenate all datasets in json library as per Json model schema and load null values for optional attributes or data sets
In this example , friends data set is optional and city , age attributes are optional
... View more