Desktop productivity for business analysts and programmers

SAS EG on Unix Server - Proc Export to csv file

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 12
Accepted Solution

SAS EG on Unix Server - Proc Export to csv file

Hello.  I'm using SAS EG on a Unix Server and it is structure to not recognize a local drive. Therefore, I must use WinSCP to transfer a file from the Server to a local location.  Is it possible to create a csv file from a SAS Dataset on the SAS Server using SAS EG and then use WinSCP to move the csv file to a local location?  Right now I'm opening the SAS Dataset and then using the Export wizard to create the csv file on the local location. The local location is a Windows 10 machine.  This process seems highly ineffecient.  Any suggestions are greatly appreciated.


Accepted Solutions
Solution
‎08-10-2016 10:23 PM
Super User
Posts: 11,134

Re: SAS EG on Unix Server - Proc Export to csv file

If this is something you do frequently it would be worth working with your IT and SAS admin to set up a location that both the server can write to and you can see as a local or shared network location from your Windows machine. If the IT or Admin won't even consider it you may need to explain about the amount of person time is wasted with associated costs to your organization.

View solution in original post


All Replies
Solution
‎08-10-2016 10:23 PM
Super User
Posts: 11,134

Re: SAS EG on Unix Server - Proc Export to csv file

If this is something you do frequently it would be worth working with your IT and SAS admin to set up a location that both the server can write to and you can see as a local or shared network location from your Windows machine. If the IT or Admin won't even consider it you may need to explain about the amount of person time is wasted with associated costs to your organization.

Super User
Posts: 19,167

Re: SAS EG on Unix Server - Proc Export to csv file

Unfortunately you don't have a ton of options. Some are:

 

1. Use system commands to essentially execute the winSCP process. You need to have X commands enabled for this, and it's usually off by default in EG and most admins won't turn it on. 

2. If you have a copy of Base SAS, that will allow you to work both locally on server as required. 

3. Set up location that is visible both on server on local desktop

4. Copy EG task - better than the manual step as you can set up as a template, but still can't be fully automated. http://blogs.sas.com/content/sasdummy/2012/12/06/copy-files-in-sas-eg/

5. Set up a script on windows that will ftp/winscp file to desktop. If this is an automated process, it could be scheduled according to when you expect the file to be complete on server. 

 

 

 

 

 

Occasional Contributor
Posts: 12

Re: SAS EG on Unix Server - Proc Export to csv file

Thank you Reeza and ballardw for your advice.  I have sent your responses to my SAS Support person asking for them to elevate the situation because as you've both mentioned, this is a poor use of manpower.  Thanks to each of you for your time.

Community Manager
Posts: 2,889

Re: SAS EG on Unix Server - Proc Export to csv file

As others have mentioned, the Copy Files task can help you to automate this within your project.  See my blog post about this exact scenario (create a CSV and download).  It's not 100% SAS code, but it is completely automated within your project.

Occasional Contributor
Posts: 12

Re: SAS EG on Unix Server - Proc Export to csv file

Thank you, Chris, for your reply.  I have just begun to read your blog and received a response from my internal SAS contact.  I find there response interesting: "our group does not support issues with copy files task since this is not part of the SAS depot, but we do allow it".  Making these types of necessary processes functional and have to depend on the buddy system continues the inefficiency.  Why isn't this a part of the SAS depot?  I will continue to raise the issue internally.  My working life is filled with these types of workarounds.  It also makes it difficult to train someone new.

Community Manager
Posts: 2,889

Re: SAS EG on Unix Server - Proc Export to csv file

@Laurel, yes, we have a number of "after market" custom tasks that help with productivity.  Some have actually made it into the product (like the Macro variable viewer, System Options viewer and many others), while some remain tasks that you have to apply yourself.  We'll continue to pursue "official" channels, but for now you should know that these tasks are widely used and support problems are rare.

PROC Star
Posts: 1,146

Re: SAS EG on Unix Server - Proc Export to csv file

What you're trying to do has nothing to do with SAS, so that's why the SAS depot doesn't contain anything related to this.

 

In my experience, IT system managers have a difficult time with SAS, as it's used for tasks quite different than they're accustomed to.

 

While making an area of disk "shareable" between Windows and unix doesn't come "out of the box", it is very straightforward to do and this has been available at every multi-OS site I've worked at. Some combination of your SAS admin people and your unix admin people should be able to set this up very easily.

 

Keep pushing!

 

Tom

☑ This topic is solved.

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

Discussion stats
  • 7 replies
  • 905 views
  • 0 likes
  • 5 in conversation