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

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 5118 views
  • 1 like
  • 3 in conversation