topic Re: proc json in SAS Programming

proc json

cbustama — Wed, 16 Sep 2020 16:06:51 GMT

Hi,

Can proc json and proc sql be used together to connect to an odbc platform the reads javascript?

Carlos

pink_poodle — Wed, 16 Sep 2020 16:18:23 GMT

To connect to odbc, you would need to use a libname statement after going though these steps:
https://documentation.sas.com/?docsetId=bidsag&docsetTarget=p1t9q2knb9tq5ln101dkrdsa9ymf.htm&docsetVersion=9.4&locale=en
After you have connected, it it understands java then you can use proc json. I am not sure about proc sql, you can find out by trying it.

BillM_SAS — Thu, 17 Sep 2020 13:25:23 GMT

PROC JSON only writes data in JSON format. To read JSON, you can use the JSON Engine in a Libname statement.