Hi there, I have SAS 9.4 (TS1M4) and I find the following problem for JSON engine: 1. The variable type defined in JSON MAP is ignored. If JSON MAP define as numeric, while JSON DATA shows characters, JSON engine just set value as missing. No warning in SAS log window. 2. The variable length defined in JSON MAP is ignored. If JSON data have length more than defined in JSON MAP, JSON engine can still convert it into SAS data set with length larger than in MAP. If JSON data is missing, the generated SAS data set will have the variable with missing value and length 8, not the length defined in MAP. 3. If JSON data file is big, the SAS JSON engine will run for ever. Here is my test of computational time: Data file size: 12M Loading time 17.93 seconds Data file size: 24M Loading time 2:22.39, which is 2.5 minutes Data file size: 87M Loading time 45:53.82, more than 45 minutes Data file size: 2.8G Loading time -- not finish for 12 hours Please confirm the above issues. It will be very helpful if the next version of JSON engine can handle them. Please let us know the estimated date of the next version release. Thanks, Luke
... View more