topic Re: How to output proc print to desktop from SAS EG Server? in SAS Enterprise Guide

How to output proc print to desktop from SAS EG Server?

RobF — Thu, 07 Apr 2016 20:51:36 GMT

I'm having trouble outputting a proc print table to my desktop. We have a SAS EG v6.1 license installed on a server.

I'm receiving the following error:

ERROR: Insufficient authorization to access C:\HH_Providers.pdf

when I run my code:

ods pdf file="C:\HH_Providers.pdf";

PROC PRINT DATA=WORK.SORTTempTableSorted style(header)={just=c}

NOOBS

LABEL

;

VAR SVC_QTR MEMBNO MEMB_NAME HH_NAME SVC_PROVIDER SVC_DATE DIAG_IND / style(data)={just=c};

BY SVC HH_NAME;

FORMAT

SVC_DATE MMDDYYS8.;

LABEL SVC_QTR="# of Qualifying Visits/Episodes"

MEMBNO="Member Number"

MEMB_NAME="Member Name"

HH_NAME="Home Health Provider"

SVC_PROVIDER="Healthcare Provider"

SVC_DATE="Visit/Episode Date"

DIAG_IND="Diagnosis Indicator";

RUN;

ods _all_ close;

Re: How to output proc print to desktop from SAS EG Server?

JuanS_OCS — Thu, 07 Apr 2016 21:01:55 GMT

Try writing the pdf to a different location than c:, as in a folder where you have permissions.

Generally Windows protects to write directly on c:

Re: How to output proc print to desktop from SAS EG Server?

CaseySmith — Thu, 07 Apr 2016 21:02:47 GMT

Remember, the paths specified in code are from the context of the server. So, when you specify "C:\HH_Providers.pdf" in your code, SAS is trying to write that file on the SAS server's host machine. The user that you are logged into EG as is evidently not authorized to access "c:\" on the server.

Re: How to output proc print to desktop from SAS EG Server?

RobF — Thu, 07 Apr 2016 21:13:07 GMT

I tried writing to my H: drive, still no luck:

ERROR: Physical file does not exist, H:\HH_Providers.pdf.

The weird thing is that I *can* export datasets to my desktop from EG using the Export wizard. But not when using ods statements to output files from a procedure.

Re: How to output proc print to desktop from SAS EG Server?

Reeza — Thu, 07 Apr 2016 21:34:47 GMT

The server can't see your C or H drive.

You our need to figure where it can see and where you can create files - most likely a path on the server.

Re: How to output proc print to desktop from SAS EG Server?

Kurt_Bremser — Fri, 08 Apr 2016 06:53:50 GMT

Your situation will look like this:

Desktop --------- H: ---------> File Server

| X

via EG H: mount on the SAS server does not exist, but would be needed

| X

V X

SAS server ---------------------------------

Re: How to output proc print to desktop from SAS EG Server?

BrunoMueller — Fri, 08 Apr 2016 07:23:16 GMT

As already mentioned the SAS Server can not see your local drives. However Enterprise Guide has the functionality to download results to your local computer. Follow the steps below.

In the properties of your code within Enterprise Guide, you can specify the output format you want like HTML, PDF etc.
when you run the code you will get an icon in your processflow representing the result.
Using your RightMouseButton on the result choose Export as step in project. This will allow you to download the result from the SAS server to your local computer.

Bruno

Re: How to output proc print to desktop from SAS EG Server?

RobF — Tue, 12 Apr 2016 18:08:05 GMT

Thank you Bruno - this is the best workaround solution for now.