Hi Tom, This seems to work to a certain point, but then errors due to invalid JSON in input near line 5 column 1: NOTE: The infile "\\cagv22\QuoteData\Archive\integra_qhv5_extract-YG-2019.09.22.json" is: Filename=\\cagv22\QuoteData\Archive\integra_qhv5_extract-YG-2019.09.22.json, RECFM=V,LRECL=32767, File Size (bytes)=1956860659, Last Modified=23 September 2019 01:23:59 o'clock, Create Time=23 September 2019 11:42:47 o'clock NOTE: The file FIXED is: Filename=C:\Users\NANDEE~1.SIN\AppData\Local\Temp\SAS Temporary Files\_TD3344_INTSAS02_\#LN00061, RECFM=V,LRECL=32767,File Size (bytes)=0, Last Modified=23 September 2019 16:27:07 o'clock, Create Time=23 September 2019 16:27:07 o'clock NOTE: 97655 records were read from the infile "\\cagv22\QuoteData\Archive\integra_qhv5_extract-YG-2019.09.22.json". The minimum record length was 1781. The maximum record length was 32767. One or more lines were truncated. NOTE: 123154 records were written to the file FIXED. The minimum record length was 1. The maximum record length was 32767. NOTE: DATA statement used (Total process time): real time 58.65 seconds cpu time 5.13 seconds 1474 libname myjson json fileref=fixed; NOTE: JSON data is only read once. To read the JSON again, reassign the JSON LIBNAME. ERROR: Invalid JSON in input near line 5 column 1: Illegal JSON string character detected. ERROR: Error in the LIBNAME statement. 1475 1476 proc copy inlib=myjson outlib=work; 1477 run; ERROR: Libref MYJSON is not assigned. NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE COPY used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The SAS System stopped processing this step because of errors. Regards Nandeep
... View more