topic Re: Proc export on Enterprise Guide in SAS Procedures

Proc export on Enterprise Guide

kabzi_5 — Tue, 27 Oct 2015 08:03:48 GMT

Good day

i want to export data set i have queried using proc export code on Enterprise Guide 5.1, everytime i run the below code i receive an error message,

PROC EXPORT DATA= WORK.prvmth1

OUTFILE= "C:\Users\kabzi\Desktop\JUNK\prvmth1.CSV"

dbms=csv

replace;

RUN;

And the error message is: ERROR: Insufficient authorization to access /mtnx290/BAF/config/Lev3/SASAppAnalytics/C:\Users\kabzi\Desktop\JUNK\prvmth1.CSV.

Is the above statement supported on EG 5.1? if not which statement should i be using in order to export large amount of data?

Re: Proc export on Enterprise Guide

gamotte — Tue, 27 Oct 2015 08:59:10 GMT

Hello,

You are executing your program on a remote server which has no visibility on your local files.

You can either export your table to a remote CSV and retrieve it (e.g. by FTP) or execute your program locally

which supposes that the table You want to export is in your local work.

Re: Proc export on Enterprise Guide

Steelers_In_DC — Tue, 27 Oct 2015 15:23:47 GMT

Without the right license this will not work. Using enterprise guide you can either use 'send to' and select excel word or powerpoint, or in the file menu select export.

Re: Proc export on Enterprise Guide

SASKiwi — Tue, 27 Oct 2015 18:50:49 GMT

CSV export using PROC EXPORT is available in Base SAS. Talk to your SAS administrator to find out what shared folder on your remote SAS server you can use for your export files.