topic JSON Hierarchy in SAS in SAS Programming

JSON Hierarchy in SAS

Syedilyas_Sas — Mon, 27 May 2019 23:20:27 GMT

i have a customer data table and would like to create a JSON output file using SAS, in specific hierarchy similar to one below.. Thanks

[

{

"Entity" : "Sale",

"TransactionID" : "20190110_AC879",

"Fields" : {

"type" : "Individual",

"cust_name" : "Bob Lee",

"item_code" : "BV9849",

"amt_prItem" : "99.99",

and so on....

}

{

"Entity" : "Sale",

"TransactionID" : "20190123_ZR067",

"Fields" : {

"type" : "Individual",

"cust_name" : "Sarah Doe",

"item_code" : "BV8549"

"amt_prItem" : "15.09"

and so on..

}

]

Re: JSON Hierarchy in SAS

ChrisNZ — Mon, 27 May 2019 22:44:10 GMT

What's your SAS table like?

Post the data as a data step or proc sql please.

Re: JSON Hierarchy in SAS

Syedilyas_Sas — Mon, 27 May 2019 23:36:42 GMT

example which i shared was just the made up table and the actual data is critical and sensitive to the business..

Please feel free to pick any table from sashelp for explation purpose.. all i need is to display each observation in a hirarchial manner... much apperiate

Re: JSON Hierarchy in SAS

ChrisNZ — Tue, 28 May 2019 01:41:23 GMT

Have you read this?

https://documentation.sas.com/?docsetId=proc&docsetTarget=p1n0o64iiv77win10abhx582as2s.htm&docsetVersion=9.4&locale=en#p1n0o64iiv77win10abhx582as2s

If yes what's the limitation?

Re: JSON Hierarchy in SAS

Syedilyas_Sas — Tue, 28 May 2019 06:04:15 GMT

Thanks a lot Chris for your prompt respond.. in the example that i have provided, specially the "TransactionID" is unique for each observation and drives the othes values. Since the data contains numerous records which infact limiting me to write the code for each transaction id.. So any assistance with the code would be a great help

Re: JSON Hierarchy in SAS

BillM_SAS — Thu, 27 Jun 2019 18:20:30 GMT

To a previous question about creating hierarchical JSON output from SAS, I wrote a SAS program that produced hierarchical JSON output from the "shoes" data set in SASHELP. Take a look at that program and see if you can modify it for your purposes.