topic Json file import in SAS Programming

Json file import

BrahmanandaRao — Fri, 22 Jan 2021 09:39:30 GMT

Hi Guys

We are using proc import procedure to import csv excel txt files into SAS

so how to import JSON files into SAS and how export JSON files

Re: Json file import

andreas_lds — Fri, 22 Jan 2021 09:50:33 GMT

Depends on the sas version you have.

Check if you can use something like libname jlib json .... See docs for details.

Re: Json file import

Ksharp — Fri, 22 Jan 2021 11:17:19 GMT

Import json file by json engine:

filename x 'c:\temp\x.json';
libname j json fileref=x;
proc copy in=j out=work;
run;

Export json ,check PROC JSON .