Hi all, I'm pretty new with trying to export json file from sas. Can I please get some help on how to export a nested json with proc json? Thanks in advance. So, what I'm trying to get is something like: [ {"person_id": "12345", "timestamp":"Tue Jun 7 07:21:50 2022", "message":"sample", "items":[ {"category_type":"cat1", "category_status":"approved", "details": [ {"subcategory_code":"subcat1", "subcategory_total":100} ,{"subcategory_code":"subcat2", "subcategory_total":50 } ] }, {"category_type":"cat2", "category_status":"pending", "details": [ {"subcategory_code":"subcat1", "subcategory_total":200} ,{"subcategory_code":"subcat2", "subcategory_total":300} ] } ] }, {"person_id": "56789", "timestamp":"Tue Jun 7 07:21:50 2022", "message":"sample", "items":[ {"category_type":"cat3", "category_status":"pending", "details": [ {"subcategory_code":"subcat1", "subcategory_total":10} ,{"subcategory_code":"subcat2", "subcategory_total":20} ] }, {"category_type":"cat4", "category_status":"approved", "details": [ {"subcategory_code":"subcat1", "subcategory_total":30} ,{"subcategory_code":"subcat2", "subcategory_total":50} ] } ] } ]
... View more
