BookmarkSubscribeRSS Feed
miki7
Obsidian | Level 7

Hi,

we have problem with FILENAME statement and PROC HTTP procedure working with https sources.

Let's assume we have all proxy options settings right. 

Every filename-based download, or http request from sas code works fine, BUT ONLY ON HTTP, not https.

 

Could someone give me some hint to solve this? We have installation summarized in deployment registry attached to this post.

 

Only workaround was to use filename pipe and wget, but this options is really not friendly with our windows admins, so we really need to find working sollution.

 

We've been looking up for solution for months already, tried some hotfixes recommended by support and still no succes.

 

Thank you very much!

Michal

2 REPLIES 2
Ksharp
Super User

That is very cumbersome for SAS. You need configure the private/public key at sas side.

Check proc http documentation or support.sas.com .

 

Or you could try to use CURL ( the third part software ) since you could use PIPE command .

miki7
Obsidian | Level 7

Hi @Ksharp

thanks for your fast reply.

Yes, we did steps from https://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#p19qqqyq9te9u3n1oq8f...

 

BUT

did we do them right?

at first i want to tell that it  Worked on my personal sas 9.3 but not in the sas installed in our company.

 

We are downloading sharable file from googledocs

We have done this:

downloaded google public certificate from browser.

created truststore

added certificate to truststore

set jvm options

reseted object spawner

 

still didnt work. Proc http said hostname not found and filename just stucked the sas execution.

 

BUT when we tried some file on standard HTTP it worked like a charm!

 

Is there something we could have done wrong?

Thank you very much,

Michal

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1973 views
  • 0 likes
  • 2 in conversation