DATA Step, Macro, Functions and more

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

Reply
Respected Advisor
Posts: 3,777

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

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
Super User
Posts: 9,691

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

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

New Contributor
Posts: 2

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

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.
Ask a Question
Discussion stats
  • 2 replies
  • 2668 views
  • 0 likes
  • 3 in conversation