https://communities.sas.com/t5/SAS-Enterprise-Guide/Json-parse/m-p/781862#M39864 You need a map for SAS with hierarchical sources (XML, JSON). Look at this paper as a guide: <A href="https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2018/1734-2018.pdf" target="_blank">https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2018/1734-2018.pdf</A><BR /> Tue, 23 Nov 2021 05:57:31 GMT AlanC 2021-11-23T05:57:31Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Json-parse/m-p/781663#M39859 Hi all,<BR />I've a json data which is like below I need to get the required fields and after getting the required fields in one place need to create a sas table for those fields. Can anyone help me out to create the sas table.<BR />Below is the data:<BR />"TotalRecords": 2, "Items": [ { "CreatedUTC": "2021-10-29T12:37:38.400Z", "Description": "OP - 064913505 - RN: 61 WER STRT - Ship To Consumer", "cid": "5690bf70-834a-", "cuc": "27e3c27b-5878", "Items": [ { "OQty": 1, "PN": "Wi78a5605", "Qty": 1, "Prttrs": { "Desc": "GLASS CAFÉ WHEEL DISPEN", "IsBatch": false, "IsInvCtrl": true, "IsSerialized": false, "NonTaxable": false, "ProdType": "1001" } } ], "EDUTC": "2021-10-18T17:00:00.000Z", "LoadNum": "1051321-422-422-20210930", "LoadType": "1001", "ModifiedUTC": "2021-10-29T12:37:38.400Z", "Status": "1001", "ID": "1104", "UN": "10430789" }, { "CreatedUTC": "2021-06-18T05:19:03.726Z", "Description": "Order Part - 060401180 - RAMARK: 40 SHIRUPURA RD - Ship To Consumer", "cid": "5690bf70-834a-4418-b0d1-5ed34cd5f506", "cc": "27e3c27b-5878-4956-99ae-6255987368aa",}]}.<BR />FROM the above data I just need some fields to be as columns for sas table which are ID,UN, DESCRIPTION,EDUTC just date only,PN,QTY. Mon, 22 Nov 2021 06:57:28 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Json-parse/m-p/781663#M39859 Pandu2 2021-11-22T06:57:28Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Json-parse/m-p/781862#M39864 You need a map for SAS with hierarchical sources (XML, JSON). Look at this paper as a guide: <A href="https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2018/1734-2018.pdf" target="_blank">https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2018/1734-2018.pdf</A><BR /> Tue, 23 Nov 2021 05:57:31 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Json-parse/m-p/781862#M39864 AlanC 2021-11-23T05:57:31Z