topic Re: Exporting ODS output to Local Computer with Remote Installation of SAS EG 6.1 in SAS Enterprise Guide

Exporting ODS output to Local Computer with Remote Installation of SAS EG 6.1

BKindle — Fri, 20 Nov 2015 17:49:00 GMT

Hello,

I have SAS (Enterprise Guide 6.1) installed on a remote SAS server with no local server available. With that being said, is it possible to programatically pass data from one environment to the other (e.g. import data with proc import or export data with ODS)? Or is it only possible to accomplish this using SAS's built in wizards (e.g. file > import data)? I apologize for my ignorance as I am new to Enterprise Guide.

Here is a simple example of something I would like to do:

/* Running on SASApp Remote Server */

Data test;

set sashelp.class;

run;

ods _all_ close;

ods pdf file = "C:\Users\Test.pdf";

proc report data = test nowd;

run;

ods pdf close;

ods listing;

/* End of Code */

I get an error in the log saying: "ERROR: Insufficient authorization to access C:\Users\Test.pdf"

Is it possible to make a code like this work given that SAS EG is only installed remotely? In case it makes a difference, I do appear to have SAS/ACCESS Interface to PC files liscensed.

Any guidance you all can offer would be much appreciated and please let me know if additional information is needed.

Thanks!

Re: Exporting ODS output to Local Computer with Remote Installation of SAS EG 6.1

ballardw — Fri, 20 Nov 2015 20:08:06 GMT

References to files will have to be in relation to how the server sees them. When you reference "C:\xxx" you are telling the server to look at its own C drive, not yours.

You'll likely need to work with your SAS admin and possibly IT to get permissions and assignments set up.

Re: Exporting ODS output to Local Computer with Remote Installation of SAS EG 6.1

Reeza — Fri, 20 Nov 2015 20:14:09 GMT

You'll need to create the file on a path you have access to on your server and then download the resulting file. There's some posts by Chris Hemedinger

http://blogs.sas.com/content/sasdummy/

There's a custom task that enables this, but I'm not sure if there's a programattic way of achieving this as well.

http://blogs.sas.com/content/sasdummy/2015/03/12/enterprise-guide-71-tasks/

Re: Exporting ODS output to Local Computer with Remote Installation of SAS EG 6.1

BKindle — Wed, 25 Nov 2015 16:49:25 GMT

Thank you!