Exporting Results to Excel

NOTE:  You cannot export results to Excel in Version 5.0.   This functionality will be added back in the next release.

You may export your report information to an Excel file. Each section of data will be present in the Excel file as a separate worksheet.

Notes:

• You must have the Excel application installed on your computer for this function to work.
• This option will not be available if the "View Multiple Joinpoint Models" option on the output viewer is selected.

To export information (data) from a Joinpoint run, first select Output > Export > Excel... from the main menu and then, depending on the data you desire, select one or more of the following:

• Filename – The name of the excel file to create. You can press the Browse button to choose a location for the file.
• Export All – Choose this option to automatically select all of the options below.
• Data – Choose this option to export the observed and predicted values for each observation.
• Model Estimates – Choose this option to export the model estimates and related information.
• Jump Model – This feature will be available in a future version of Joinpoint.
• APCs – Choose this option to export the APCs.
• AAPCs – Choose this option to export the AAPCs.
• Model Selection – Choose this option to export information about the model selection process.
• Comparison - Choose this option to export data about your Pairwise Comparison Test or Multi-Group Clustering.
• Selection Results – Choose this option to export information about the data dependent selection method process.
• MADWD – Choose this option to export information about the minimum apc difference worth detecting results.

Once you have selected one or more of the above options, you will need to address the following:

• Output By-Variables As – When exporting By-Variables, Joinpoint can export the numeric representation of the By-variable or the By-variable label (either in quotes or not).
• Export Models – Joinpoint can export all of the joinpoint models per cohort or it can export only the final selected joinpoint model.
• Missing Characters – Sometimes data values can be missing. Joinpoint offers several export options for missing values. For SAS users, a period is considered a missing value.
• Remove Flags Marking the Joinpoints - Whether to include a column with Joinpoint flags.
• Remove Flags Marking the Best Models - Whether to include an asterisk indicating which model is the best one.
• Output All Models in the Same Column - Whether to include a column indicating the model.
• Output Variable Names Before Each By-Group - Redisplays the column headers for each new By-Group.
• Load Defaults - This option will load your default settings for this window (your defaults are automatically loaded when the window is displayed). The Filename and Sections to Export are not included in the default settings.
• Set As Default - This option will save all of your settings in this window (excluding the Filename and the Sections to Export). This button is only enabled after you make changes to your settings.