Your issue is that you need to whitelist the passive port in your firewall.... comments like you have to use SFTP is incorrect.  ... View more

Yes, my mistake - sorry for the confusion. That compress statement worked for me. ... View more

Awesome! Thanks a lot, Tom. Appreciate the quick help. ... View more

I wanted to follow-up on my previous message. Can anyone explain the best way to make a paginated request in SAS. Here is the documentation I am just not sure how to translate this into my SAS code.  https://shopify.dev/api/usage/pagination-rest It looks like I need to somehow access the rel="next" that prints in the headers file to tell SAS to pull the next set of products.  ... View more

Does this https://blogs.sas.com/content/sgf/2020/07/30/curl-to-proc-http/ help? ... View more

As you have found, there does not appear to be a way to get the export statement to give you the JSON format you want. While not ideal, one possibility is to write a program to strip off the outer array characters after the JSON file is created. Another possibility might be to write a program to dynamically create the PROC JSON code that utilizes WRITE statements to produce the desired output. A proof-of-concept of this technique is in this post. I do not know enough about your requirements to be able to say if the dynamically generated PROC JSON code will work in your case. ... View more

Thanks for the response, Chris. Yes, I was hoping just to add the modified date as another column in the dataset. Also, correct, it's the modified date of the file on the FTP. I am still looking into what can be done and also considering Kurt's comment. ... View more