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.

Reply
zd
N/A
Posts: 1

Output SAS Miner data to Excel.

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

Thanks,

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

Ask a Question
Discussion stats
  • 1 reply
  • 1231 views
  • 1 like
  • 2 in conversation