Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

Output SAS Miner data to Excel.

Accepted Solution Solved
Reply
zd
N/A
Posts: 1
Accepted Solution

Output SAS Miner data to Excel.

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

Thanks,


Accepted Solutions
Solution
‎09-22-2017 12:26 PM
Occasional Contributor
Posts: 17

Re: Output SAS Miner data to Excel.

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

View solution in original post


All Replies
Solution
‎09-22-2017 12:26 PM
Occasional Contributor
Posts: 17

Re: Output SAS Miner data to Excel.

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

SAS Employee
Posts: 179

Re: Output SAS Miner data to Excel.

Posted in reply to adjgiulio

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 1529 views
  • 1 like
  • 3 in conversation