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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.