topic Re: calling "copy files" step within a SAS EG program in SAS Enterprise Guide

calling "copy files" step within a SAS EG program

roohaa — Mon, 10 Sep 2018 19:24:56 GMT

I want to read an excel file from local machine while my EG is connected to a server box and I cannot use local address like c:\...

I use task/data/copy files menu and copied the file to the server and then read it from there using a proc import. I need to call this step within my ptogram files to make sure that the latest version of the file is uploaded and read. Is there anyway that I call that step (Copy File) in a sas program within EG?

Re: calling "copy files" step within a SAS EG program

SuryaKiran — Mon, 10 Sep 2018 19:43:47 GMT

I don't think this is possible. What operating system is your server and your local machine.

One solution that comes into my mind is synchronizing the files using FTP Scripts. WinSCP is one such tool for transferring files. Check this

Re: calling "copy files" step within a SAS EG program

ChrisHemedinger — Mon, 10 Sep 2018 19:57:52 GMT

No, you can't script the Copy Files task in a SAS program. In SAS, you can use FILENAME FTP (alluded to by @SuryaKiran) or you can reference the file (if possible) from a shared network location.

The Copy Files task does not use SAS code for its work -- it copies the files in an FTP-like manner, but using the SAS session connection in place of the traditional FTP server. Since the action is initiated by EG, you can't cue this up in a SAS program.

Re: calling "copy files" step within a SAS EG program

roohaa — Mon, 10 Sep 2018 20:07:33 GMT

I am using the SAS EG on linux box and the data or on windows. There is a security barrier that does not let me use proc import. However, I can use import/Copy Files in EG interface to read the data.
I need to replicate that process--copying the file from local to a temporary folder and then importing from there.

Re: calling "copy files" step within a SAS EG program

roohaa — Mon, 10 Sep 2018 20:09:39 GMT

Right, for sharing and simplicity purposes, I was trying to import data through SAS utilities. Now, I am using the data/import data to read the data but it cannot be scripted as there is one step of uploading the file to a temporary space and I am not sure how to script that.

Re: calling "copy files" step within a SAS EG program

SASKiwi — Mon, 10 Sep 2018 21:36:25 GMT

You can't run a server-based process (using SAS or something else) to do your file copy because of the security barrier. Talk to your SAS/IT administrator about setting up a folder location accessible by your SAS server where you can copy the file first before running your code. Preferably this folder location (share) should be accessible from both Linux and Windows.

Re: calling "copy files" step within a SAS EG program

Cotydog981 — Thu, 14 Nov 2019 20:27:10 GMT

An alternative is to call your Programs in order by using an ordered list which will accept the copy functionality as a step.

This way we ensure that the most recent file gets copied.