BookmarkSubscribeRSS Feed
Calcite | Level 5 bk4
Calcite | Level 5


I am trying to upload a csv file from SAS to Sharefile dropbox using the below code.

When I run the below code, I get 'Physical file does not exist' error. I guess it is not able to translate/read the dropbox URL.


Has anyone done something similar before? 



filename _inbox "";/* Path of the Folder where we wish to upload the document */
filename class "/staff/XXX/userid/test.txt"; /* Path of the Folder where the document is present */

proc http method="post" 
webusername="" webpassword="XXXX" 
proxyport=8080 in=class


Log snippet as below -

Proxy Host =
Proxy Port = 8080
METHOD = post
CT = application/x-www-form-urlencoded
In = /staff/xxxx/userid/test.txt
Out = 
Web Auth User Name =

38 run;

ERROR: Physical file does not exist, 
ERROR: Generic HTTP Client Error
NOTE: PROCEDURE HTTP used (Total process time):
real time 0.28 seconds
cpu time 0.00 seconds

2 The SAS System 10:55 Wednesday, September 26, 2018

NOTE: The SAS System stopped processing this step because of errors.



Super User

The out= option has to point to a local file where the returns from the HTTP request are to be stored. The target for the post is solely in the url= option.


A filename without a specific engine always has to point to a file in the local filesystem. Protocols (http://) do not work, and since the pathname in the filename statement does not satisfy the requirements of an absolute pathname, it is considered relative and appended to the current working directory of the SAS process.

Community Manager

Aside from @Kurt_Bremser's advice, I suspect that you will not be able to upload a file with Basic Auth (the webuser/password approach).  The ShareFile API, like Box or Google Drive, will require OAuth2 -- which might require that you register an "app" as a developer and then get an access token.  This is needed because you'll need to grant the app the appropriate permissions to upload a file to your account.  (Things have become lots more complex since the FTP days, right?) 


Some services allow you to register a webhook that makes this a little simpler -- not sure if ShareFile is one of those.


It's definitely possible to do, just some more code.


See this thread about using the Box API.



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg



Back in the Classroom!

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

View all other training opportunities.

Discussion stats
  • 3 replies
  • 3 in conversation