topic URL access method "ERROR: SSL Error: Missing CA trust list." in SAS Programming

URL access method "ERROR: SSL Error: Missing CA trust list."

data_null__ — Thu, 05 Feb 2015 16:29:16 GMT

I can run this and it works.

data _null_; 
   filevar='http://support.sas.com/techsup'; 
   do _n_ = 1 to 12; 
      infile dummy url filevar=filevar length=len eof=eof debug;
      input; 
      put _infile_; 
      end;  
 eof:
   stop; 
   run;

I want to run this but it gives me the SSL error; Of course since I don't know what I'm doing I can't figure what I need to change or add etc. I think it is something to do with a Google account and I tried some USER= and PASS= bits but that hasn't got me any further. I've also searched support.sas.com and here for similar but nothing (that I understand) so far. Anyone know how to make this work?

data _null_; 
   infile cards; 
   length filevar $80; 
   input filevar;
   infile dummy url filevar=filevar eof=eof lrecl=1024 debug;
   do while(1);
      input; 
      put _infile_; 
      end; 
 eof: stop; 
   cards; 
http://translate.google.com/?langpair=fr|en&q=bonjour+madame
;;;;
   run;

My OS is UNIX SAS 9.3

Re: URL access method "ERROR: SSL Error: Missing CA trust list."

Ksharp — Fri, 06 Feb 2015 09:42:50 GMT

John,

Yeah. SSL means It is a encrypted URL , You can't use it in Filename + URL .

Check proc http ; to import such URL .

at support.sas.com

at blogs.sas.com

Xia Keshan

Re: URL access method "ERROR: SSL Error: Missing CA trust list."

zencosap — Thu, 14 Jul 2016 19:55:05 GMT

you probably has some expired trusted certificate chains in your PEM file that you are pointing to with the -SSLCALISTLOC option in your sasv9.cfg or sasv9_local.cfg. Have your security team regenerate the PEM file for you and put it on the compute tier.