Transfer SAS Data to FTP Folder

Accepted Solution Solved
Reply
Contributor
Posts: 37
Accepted Solution

Transfer SAS Data to FTP Folder

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!


Accepted Solutions
Solution
‎10-31-2017 05:44 PM
Super User
Posts: 12,148

Re: Transfer SAS Data to FTP Folder

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...

View solution in original post


All Replies
Super User
Posts: 12,148

Re: Transfer SAS Data to FTP Folder

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).

Contributor
Posts: 37

Re: Transfer SAS Data to FTP Folder

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

Solution
‎10-31-2017 05:44 PM
Super User
Posts: 12,148

Re: Transfer SAS Data to FTP Folder

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...

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 179 views
  • 2 likes
  • 2 in conversation