Transfer SAS Data to FTP Folder

[Dogo23]

Hello all, My SAS EG is setup through Linux and not windows. I've written a couple queries to my folder that I would like to move locally or to a folder I can pick up on FTP client site. This data will then be picked up by Tableau for reporting purposes. In a previous role, my SAS EG was through Windows and I was able to export a sas or excel file through a statement after the query ran. Apparently I am unable to do this with the Linux setup, so could someone please help advise what method and process I can take to place my data somewhere that I can utilize in Tableau? It was recommended by a colleague to write to a folder I can in and FTP site. Not sure how to do that or what the best method is. Let me know if you need calcification or more details. Thanks!

[ballardw]

Can you show an example of code that worked previously?

The Filename statement with FTP options would be the likely choice but your SAS admin may have restricted use (locked-down).

[Dogo23]

Hi Ballerdw,

It hasn't actually worked before, so I don't have an example to provide. In an old role when I had SAS setup with Windows, I just used proc export and place a CSV file on a personal or shared drive.

what is the proper syntax for a filename statement?

Thanks

[ballardw · Accepted solution]

Check the documentation for the details of Filename FTP. Since FTP may or may not require user credentials like user name, password and possibly need to issue command to the FTP server to set the target directory I'm not even going to try to copy all of the documentation that may be involved.

http://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.2&docsetId=lestmtsglobal&docsetTarget...