BookmarkSubscribeRSS Feed
Prajna_450
Fluorite | Level 6

Hi Guys,

 

I have statExplore node attached with my File import node.I want to export the output window of statExpolore node on to excel. I am not sure if there is a way out without using SAS code (code editor node).

 

please share information if there is one.

 

thank you,

Prajna

 

 

2 REPLIES 2
MikeStockstill
SAS Employee

Hello Prajna_450:

 

The Output panel in the Results window of the StatExplore node is a LST (text) file.  To save it, take these steps:

 

 - Run the StatExplore node.  View the results.

 - In the Results window, click the Output panel (or click View -> SAS Results -> Output).

 - With the Output panel active, click File -> Save As.., and follow the steps in the Wizard.

 

Those steps work for any of the panels in the Results window.  Graph panels are saved as BMP files.

 

You can also save the underlying data that creates each graph or table.  

 

 - Select the graph of interest.

 - With the graph active, click the Table icon in the toolbar. A table is displayed.

 - With the table active, click File -> Save As, and you can create a SAS data set.

 

There is another way to see the underlying data sets that are used by the node.

 - Click the Explorer icon in the toolbar.

 - In the Explorer window that opens, select the Show Project Data selection box.

 - Navigate to the EMWS<n> folder that corresponds to your diagram of interest.

 - The data sets that begin with "Stat<n>_..." correspond to the data sets that are used by 

   the StatExplore node.  You can get to them by navigating to the workspace folder, or by

   writing code in a SAS Code node.  If there is a specific data set that you want to access

   in this method, then open a technical support track, send a model package, and add comments

   about which portion of the Results window data you are trying to access.  Technical support

   can offer coding suggestions.

 

 

Have a great day.

Prajna_450
Fluorite | Level 6

Hi,

 

I agree to your solution, but I to send to my client I need to send it via excel. While I am try to export the alignment looks in appropriate.

Is there any other way ?

 

Please help !

 

Thank you,

Prajna 

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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
  • 1283 views
  • 0 likes
  • 2 in conversation