Output SAS Miner data to Excel.

[zd]

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

Thanks,

[adjgiulio · Accepted solution]

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.

G

[DougWielenga]

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