BookmarkSubscribeRSS Feed
cbustama
Calcite | Level 5

Hi,

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

 

Carlos

2 REPLIES 2
pink_poodle
Barite | Level 11
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&docsetV...
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
SAS Employee

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

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 403 views
  • 0 likes
  • 3 in conversation