I got error when running output to json using "proc json". The program and error message you can see bellow. 1. I have to use "fmtnumeric" options for my needs. This is not an option for me. 2. When I use "format percentvar percent10.2" instead of percent7.2 it is working, but maximum length of numeric variable is unknown. This is also not an option for me. Program: data json_sample1; percentvar=0.543; format percentvar percent7.2; run; proc json out="/tmp/r1.json" nosastags pretty; write open object; write values data; write open array; export json_sample1 / fmtnumeric; write close; write close; run; ERROR: Due to the previous error, the JSON output file is incomplete and invalid, or in some cases, unable to be created. If created, the JSON output file is retained so that you can review it to help determine the cause of the error.
... View more