topic Re: How to call URL API from SAS/WPS in SAS Procedures

How to call URL API from SAS/WPS

anitapamu2 — Fri, 28 Jul 2017 07:03:23 GMT

%let url= " " ;
filename in "C:\Users\anita.pamu\Desktop\In.txt";
filename out "C:\Users\anita.pamu\Desktop\Out.txt" recfm=v lrecl=32000;
proc http in=in out=out url="&url" method="post" ct="application/x-www-form-urlencoded" ;
run;

Re: How to call URL API from SAS/WPS

Kurt_Bremser — Fri, 28 Jul 2017 07:10:48 GMT

And what is your problem?

Re: How to call URL API from SAS/WPS

anitapamu2 — Fri, 28 Jul 2017 07:17:11 GMT

How to call Web service (Url) form SAS ? I am using 9.2 Windows Base SAS.

ERROR: Cannot load SSL support.

Here is an example of code that can trigger the error.


filename myref url "https://www.google.com";
data _null_; 
infile myref; 
run;

Re: How to call URL API from SAS/WPS

Kurt_Bremser — Fri, 28 Jul 2017 07:18:06 GMT

You already have code. What happened when you tried it, and how did the outcome not match your expectations? (Log!!)

Re: How to call URL API from SAS/WPS

Kurt_Bremser — Fri, 28 Jul 2017 07:23:10 GMT

@anitapamu2 wrote:

How to call Web service (Url) form SAS ? I am using 9.2 Windows Base SAS.
ERROR: Cannot load SSL support.

Googling for that error message got me this SAS Note as the second result:

http://support.sas.com/kb/57/595.html

You may not have the proper module installed.

Re: How to call URL API from SAS/WPS

ChrisHemedinger — Fri, 28 Jul 2017 11:36:25 GMT

Use PROC HTTP instead. I have many examples:

http://blogs.sas.com/content/sasdummy/tag/proc-http/

But you will need the SSL components in order to access any HTTPS sites.