BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
daRocha
Calcite | Level 5

Hi all


My question is related with the issue reported here:

https://communities.sas.com/t5/Developers/proc-http-can-not-return-GZIP-file-gt-64-KB/td-p/645154


I am facing the exact same issue and in the original thread, even though the issue is marked as solved, the last comment made by @SimonDawson  says:
"This will be looked at and addressed in a future release."


Has any progress been done or is there a workaround?


Thanks,

daRocha

1 ACCEPTED SOLUTION

Accepted Solutions
joeFurbee
Community Manager

Hi @daRocha,

The developer took another look at this and while the error seems to be suppressed in his testing the file is not processed. IOW, we still have an issue. I'll follow the progress of the fix and will update you when it's fixed and in which version of SAS 9.

 

Thanks,

Joe


Join us for SAS Community Trivia
SAS Bowl XXXVIII, SAS Programming: Getting Started
Wednesday, February 14, 2024, at 10 a.m. ET | #SASBowl

View solution in original post

7 REPLIES 7
andreas_lds
Jade | Level 19

Are you using the latest sas release with hotfixes applied?

daRocha
Calcite | Level 5

All updates are in place. I am currently running my code on SAS 9.4. In particular: 9.04.01M7P080520

 

andreas_lds
Jade | Level 19

Open a track with sas tech support, they should know if the bug will be fixed with m8 or if the plans to fix the issue have been abandoned.

joeFurbee
Community Manager

Hi @daRocha,

I checked with SAS R&D and found out:

The fix is in 9.4m7 and beyond and in Viya.

 

Thanks,

Joe


Join us for SAS Community Trivia
SAS Bowl XXXVIII, SAS Programming: Getting Started
Wednesday, February 14, 2024, at 10 a.m. ET | #SASBowl

daRocha
Calcite | Level 5

Hi @joeFurbee 

 

With the tests I ran it does not seem to be working with my version (9.04.01M7P080520) 

 

For example, this code works for small files:

/*API Endpoint */
%let urlLink=https://reference-data-api.kaiko.io/v1/exchanges;

/*Temp work location*/
%let dataLoc=%sysfunc(getoption(work))\kkExhange;
/*Create location and assign lib*/
options dlcreatedir;
libname kkExchan "&dataLoc.";
options nodlcreatedir;

/* Results file*/
filename KaikoEx "&dataLoc.\metaKaiko.json.gz";

proc http 
  url="&urlLink."
    method='get'
    out=KaikoEx;
  headers
    'Accept' = 'application/json'
    'Accept-Encoding'= 'gzip, deflate, br';
run;

/*Filename poiting to the results file as gzip*/
filename KaikoEx zip "&dataLoc.\metaKaiko.json.gz" gzip;
filename KaikMap temp;

/*Json libname */
libname KaikoExc json fileref=KaikoEx map=KaikMap automap=create;

/*List json file contents*/
proc contents data=kaikoExc._all_;
run;

but when I use the same code for a larger gzip file it does not work. For large files, I am using the API Endpoint to test:
https://reference-data-api.kaiko.io/v1/instruments 

 

Is there something wrong with my code or do I need to update my SAS version?

 

Thank you,

daRocha 

 

joeFurbee
Community Manager

Hi @daRocha,

Your SAS version should have the patch. We may have to open a tech support ticket to investigate. Before we do that, the developer I spoke with asked the following:

Can he provide the debug logs for the run? Setting logger App.tk.HTTPC to debug would be good to see what is going on.

 

Can you provide the logs for us here?


Join us for SAS Community Trivia
SAS Bowl XXXVIII, SAS Programming: Getting Started
Wednesday, February 14, 2024, at 10 a.m. ET | #SASBowl

joeFurbee
Community Manager

Hi @daRocha,

The developer took another look at this and while the error seems to be suppressed in his testing the file is not processed. IOW, we still have an issue. I'll follow the progress of the fix and will update you when it's fixed and in which version of SAS 9.

 

Thanks,

Joe


Join us for SAS Community Trivia
SAS Bowl XXXVIII, SAS Programming: Getting Started
Wednesday, February 14, 2024, at 10 a.m. ET | #SASBowl

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
  • 7 replies
  • 1281 views
  • 0 likes
  • 3 in conversation