cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Syedilyas_Sas
‎05-31-2019
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: JSON Hierarchy in SAS

by Fluorite | Level 6 in SAS Programming
‎05-28-2019 02:00 AM
‎05-28-2019 02:00 AM
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 ... View more

Re: JSON Hierarchy in SAS

by Fluorite | Level 6 in SAS Programming
‎05-27-2019 07:35 PM
‎05-27-2019 07:35 PM
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 ... View more

JSON Hierarchy in SAS

by Fluorite | Level 6 in SAS Programming
‎05-26-2019 10:31 PM
‎05-26-2019 10:31 PM
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..                     } } ]                           ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-31-2019 06:26 AM
Quick links