I already have the frequency table. It has columns for track, status,priority and the corresponding frequency of each combination of these variables. There is some further process which needs this data to be in json. The attached file has the example of what I could produce and what I need. Pasting it here too: I was able to produce this: Here, the variable track is at the same level as status and priority. { "info": [ [ "SASJSONExport", "1.0 PRETTY", "SASTableData+SUMMARY1", [ { "TRACK": "track_nm1", "STATUS": "Closed", "N": 21, "PRIORITY": "M" }, { "TRACK": "track_nm2", "STATUS": "Closed", "N": 15, "PRIORITY": "H" } ] ] ] } However, I want this: Here, status and priority are inside a block for each track. "summary": { "groupedData": [ { "TRACK": "track_nm1",, "data": [ { "STATUS": "Closed", "N": 21, "PRIORITY": "M" } ] }, { "TRACK": "track_nm2", "data": [ { "STATUS": "Closed", "N": 15, "PRIORITY": "H" } ] } ] }
... View more