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;
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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.