An official website of the United States government
Surveillance Research Program

Exporting Results to Text

You may access both the graph data and the report information by exporting these as text files for use with other software packages (Excel, SAS, etc.).

Notes:

  • Only what is displayed in the Output Window will be exported. For example, if only 1 decimal place is chosen, only that many decimal places will be in the exported file. Or, if the "Regression Coefficients" box is unchecked, those statistics will not be included in the exported file.
  • 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 the export option ( ) from the task bar and then, depending on the data you desire, select one or more of the following:

  • Export All – Choose this option to automatically select all of the options below.
  • *.Export.Graph.*– Choose this option to export the graphs as an image file.  Graphs can be save as BMP, JPG, PNG, or TIFF files. Each graph is saved as a separate file using the base name and location you specify, plus the specific cohort name for that graph.  You do have the option of exporting graphs in high resolution.  Please see details below.
  • *.Export.Data.txt – Choose this option to export the observed and predicted values for each observation.
  • *.Export.Model.Estimates.txt – Choose this option to export the model estimates and related information.
  • *.Export.Jump.Model.txt – Choose this option to export the jump model results.
  • *.Export.APCs – Choose this option to export the APCs.
  • *.Export.AAPCs – Choose this option to export the AAPCs.
  • *.Export.Model.Selection.txt – Choose this option to export information about the model selection process.
  • *.Export.Selection.Results.txt – Choose this option to export information about the data dependent selection method process.
  • *.Export.MADWD.Results.txt – Choose this option to export information about the minimum apc difference worth detecting results.
  • *.Export.Comparison.txt – Choose this option to export information about the Pairwise Comparison test.
  • *.Export.Final.Selected.Model.txt – Choose this option to export the number of Joinpoints in the final selected model for each cohort.

 

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).
  • Line Delimiter – Select the appropriate line delimiter for the platform on which you will be working with the exported file.
  • Field Delimiter – Each variable field in an export line will be separated by a delimiter. Joinpoint offers three types of field delimiters: Tab, Comma, Semicolon.
  • Graphs – When exporting graphs, you have the option of exporting the currently displayed graph, the graph for the final selected model of each cohort, or the graph for each cohort/model combination.  There is also an option to export the graphs in High Resolution.  Once the high resolution export option is checked, you have the ability to adjust the number of pixels involved with the width and height of each graph image.
  • 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 selected options and their filenames are not included in the default settings.
  • Set As Default - This option will save all of your settings in this window (excluding the options and filenames). This button is only enabled after you make changes to your settings.