topic Output SAS Miner data to Excel. in SAS Data Science

Output SAS Miner data to Excel.

zd — Mon, 18 Feb 2013 23:21:41 GMT

How can I output the 'exported' data from SAS miner into Excel or a *csv format?

Thanks,

Re: Output SAS Miner data to Excel.

adjgiulio — Thu, 21 Feb 2013 19:16:02 GMT

How about you add a Code node after the node where your dataset is created and then use this code in the code node:

PROC EXPORT DATA= &EM_IMPORT_DATA

OUTFILE= "your_export_location\test.xls"

DBMS=EXCELCS REPLACE;

SHEET="test";

RUN; quit;

Notice that the exported dataset you want to save becomes the import dataset in the code node. Play with the DBMS to make it work for you.

Re: Output SAS Miner data to Excel.

DougWielenga — Fri, 22 Sep 2017 16:26:41 GMT

You can also use the Save Data node available from the Utility tab. It provides you the option of saving data to Excel Spreadsheet (.XLSX format) by choosing that option for File Format in the Output Format section of the property sheet. When you choose the Excel Spreadsheet option, you can also specify the directory where you want the file to be placed in the Directory property in the same property section.

Hope this helps!

Doug