Thanks to all, and specially to Dear Gwootton : Upon updating SAS code to this....It worked like a charm. filename jobout filesrvc folderPath='/Public/Json'; data _null_; set Unq_Circuit end=eof; file jobout('test_Circuit.json') ; if _n_=1 then put '['; if not eof then delim=','; put '{"Value":' Value ' "Text":' Text'}' delim ; if eof then put ']'; run; 79 filename jobout filesrvc folderPath='/Public/Json'; 80 81 data _null_; 82 set Unq_Circuit end=eof; 83 file jobout('test_Circuit.json') ; 84 if _n_=1 then put '['; 85 if not eof then delim=','; 86 put '{"Value":' Value ' "Text":' Text'}' delim ; 87 if eof then put ']'; 88 run; NOTE: The file library JOBOUT is: Directory=/Public/Json, Folder Identifier=4880eafd-d5e5-4ae6-ad0e-7e242d0b44d9, Last Modified=10Jan2022:19:18:17 NOTE: The file JOBOUT('test_Circuit.json') is: Filename=Test_Circuit.json, URI path=/files/files/e2a8832f-03ce-46c8-ba5d-df61136c922c, File Identifier=e2a8832f-03ce-46c8-ba5d-df61136c922c, Document Type=file,Content Type=text/plain, Content Disposition=inline;filename*=utf-8''Test_Circuit.json, Encoding=UTF-8,Searchable=true,RECFM=V, LRECL=32767,File Size (bytes)=0, Last Modified=29Jul2022:19:50:59, Create Time=29Jul2022:19:50:58 NOTE: A total of 351 records were written to the file library JOBOUT. The minimum record length was 1. The maximum record length was 29. NOTE: 351 records were written to the file JOBOUT('test_Circuit.json'). The minimum record length was 1. The maximum record length was 29. NOTE: There were 349 observations read from the data set WORK.UNQ_CIRCUIT. NOTE: DATA statement used (Total process time): real time 0.66 seconds
... View more
