Thanks for that Chris, Yes I am considering using a SAS datastep to pass the JSON messages into csv file and then do a proc import so SAS can allocate the lengths, datatypes ect.  But I am almost certain SAS will bring out a solution for this just when I have completed my ‘challenge’.   Regards, Bronwen ... View more

Thanks for this Chris, this looks really exciting.   I'm just wondering if this could be adapted to accept a json message of unknown structure. So create a dataset, variable names, types, lengths dynamically based on the json we are receiving.   I am trying to build a data warehouse that uses a json message queue as its primary source of data and as the messages change over time, we want the data warehouse structure to be automatically updated.   I already have this working within SAS and loading a MS SQL database, I’m just not sure how to read in the json messages.   For instance if we get a set of messages from the queue, that may differ in structure because there has been a change within the message format, do you know of any way to create a SAS dataset with all the variables of all the messages.   Any ideas would be greatly appreciated.   Regards, Bronwen ... View more