How can I code SAS in EG to have EG add a file link (CSV,TXT etc) to the process flow?

PhilC — Fri, 11 Dec 2020 16:24:33 GMT

I would like to add a file link to a CSV file I've exported, specifically using PROC EXPORT, so that it displays in the EG project's process flow connected to the block of code the EXPORT code is written in. I can use ODS CSV, I can use EG's task, but I do not wish to for "reasons".

Any tricks for this?

This is one way I've thought of to do this:

%let csvfile="C:\ASI\ASI.csv";

*To create a EG file link to CSV file;
ods csv file=&csvfile;
     proc print data=&SysLast (obs=1) ; run;
ods csv close;

*To export to the CSV file (and not wait for ODS CSV);
proc export data=&sysLast 
     outfile=&csvfile
     dbms=csv 
     replace;
run;

Re: How can I code SAS in EG to have EG add a file link (CSV,TXT etc) to the process flow?

Sajid01 — Wed, 17 Mar 2021 12:47:57 GMT

Hello @PhilC
I have some issues with this statement.

%let csvfile="C:\ASI\ASI.csv";

If you have SAS installed locally on your machine it is fine. But if you are connecting to SAS installed on a server from SAS EG installed locally on your laptop/desktop, then the location will be on the C drive of your server and not desktop/laptop. Considering my statement above (and making changes as needed to your code) please test and let us know if there is an error.

topic How can I code SAS in EG to have EG add a file link (CSV,TXT etc) to the process flow? in SAS Enterprise Guide

How can I code SAS in EG to have EG add a file link (CSV,TXT etc) to the process flow?

Re: How can I code SAS in EG to have EG add a file link (CSV,TXT etc) to the process flow?