When you run the stored process from EG, you will be presented with a "file download" dialog. Choose to save the file in a directory of your choosing. You can specify any name for the file, but make sure that the file extension is "sas7bdat". You can then drag-and-drop the file into EG, or use the EG menu sequence
*ProcessBody;
* Force to HTML output;
%let _ODSDEST=html;
%STPBEGIN;
* Create the output table in the "magic" directory;
libname stpwork "&_STPWORK";
data stpwork.test;
x=1; y=2; z=3;
run;
* Close the HTML destination and delete the HTML file;
ods &_ODSDEST close;
data _null_;
length fileref $8 rc 8;
rc = filename(fileref, "&_STPWORK.main.html");
rc = fdelete(fileref);
run;
%STPEND;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.