I'm trying to do a simple task of reading a file from a webpage in to SAS. This is something I do regularly over HTTP connections but the first time I've done it with HTTPS.
I am getting errors when I attempt this is 9.2 but not with the identical code in 9.1.3 (with SAS/Secure installed).
I need to be able to do this directly from SAS - so piping via cURL is not an option.
This code:
filename foobar url 'https://>>>ADDRESS HERE<<<<' debug lrecl=20000;
data x;
infile foobar length=linelen;
input stringvar $varying20000. linelen;
run;
Here are the results with some websites:
https://www.dellbatteryprogram.com/regionalSupport.aspx
9.1.3 connects to server fine
9.2 ERROR: Hostname www.dellbatteryprogram.com not found
https://api.betfair.com/exchange/v5/BFExchangeService.wsdl
9.1.3 connects to server fine
9.2 ERROR: Hostname api.betfair.com not found
https://implicit.harvard.edu/implicit/demo/featuredtask.html
9.1.3 connects to server fine
9.2 connects to server fine
Any thoughts on why this may be - or anything I should be doing to configure SSL for 9.2 that is different from 9.1.3 would be very much appreciated.
Simon