BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
zd
Calcite | Level 5 zd
Calcite | Level 5

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

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
adjgiulio
Obsidian | Level 7

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

2 REPLIES 2
adjgiulio
Obsidian | Level 7

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
SAS Employee

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

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

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