Hi all,
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.
Below is the data:
"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",}]}.
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.