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

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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