• <GetStart>
  • CSPro User's Guide
    • The CSPro System
    • Data Dictionary Module
    • The CSPro Language
    • Data Entry Module
    • Batch Editing Applications
    • Tabulation Applications
    • Data Sources
    • CSPro Statements and Functions
    • Templated Reporting System
    • HTML and JavaScript Integration
    • Action Invoker
    • Appendix
      • Appendix A - Installation
      • Appendix B - Keys Summary
      • Appendix C - Menu Summary
      • Appendix D - Toolbar Summary
      • Appendix E - Application Properties
      • Appendix F - Converting Within IMPS or ISSA
      • Appendix G - Errors in Censuses and Surveys
      • Appendix H - File Types
        • File Types
        • JSON Specification Files
        • SQLite Use in CSPro
        • Importing Data to CSPro Format
        • Locking Application Files
        • Temporary Data File
        • CSPro DB File Format
        • Files Description
          • Data Dictionary File (.dcf)
          • Data Entry Application File (.ent)
          • Forms File (.fmf)
          • Logic File (.apc)
          • Message File (.mgf)
          • Question File (.qsf)
          • Application Properties File (.csprops)
          • Program Information File (.pff)
          • Binary Data Entry Application File (.pen)
          • Index File (.csidx)
          • Notes File (.csnot)
          • Status File (.sts)
          • Paradata Log File (.cslog)
          • Operator Statistics File (.log)
          • Listing File
          • Frequencies File
          • Batch Edit Application File (.bch)
          • Edit Order File (.ord)
          • Saved Arrays File (.sva)
          • Tabulation Application File (.xtb)
          • Table Specifications File (.xts)
          • Tables File (.tbw)
          • Area Names File (.anm)
          • Table Matrices File (.tab)
          • Table Matrices Index File (.tabidx)
          • Frequency Specification File (.fqf)
      • Appendix I - JSON Representations
  • <CSEntry>
  • <CSBatch>
  • <CSTab>
  • <DataViewer>
  • <TextView>
  • <TblView>
  • <CSFreq>
  • <CSDeploy>
  • <CSPack>
  • <CSDiff>
  • <CSConcat>
  • <Excel2CSPro>
  • <CSExport>
  • <CSIndex>
  • <CSReFmt>
  • <CSSort>
  • <ParadataConcat>
  • <ParadataViewer>
  • <CSCode>
  • <CSDocument>
  • <CSView>
  • <CSWeb>

Frequencies File

The frequencies file contains the frequency tables generated by using the Freq statement or when calling the Freq.save function. When using frequencies in an application, you can specify the name of the file in the File Associations dialog. You can also manually specify the name using the Freqs attribute in a PFF file.
If no frequencies file is specified, then frequency tables will be saved to the listing file if possible. Only text, HTML, and JSON listing files support the saving of frequencies.
Frequency File Formats
CSPro can write frequency tables in several formats. CSPro will save tables in a format based on the extension of the frequencies filename.
FormatExtensionResults Viewer
Table.tbwTable Viewer
Text.lstText Viewer
HTML.html / .htmDefault Internet browser
JSON.jsonDefault JSON viewer
Excel.xlsxMicrosoft Excel (or other application associated with Excel files)
Using any extension not in the table above will result in a text frequencies file. When writing text frequencies, you can use the ListingWidth PFF attribute to modify the width of the tables.
Frequency Table
A frequency table contains between five and eight columns. The order of the columns depends on the file format.
  • Value: The value (code) of the row.
  • Label: The label of the row, taken from an item's value set.
  • Frequency: The number of times this row's value was tallied.
  • Cumulative Frequency: The number of times this row's value was tallied added with the previous rows' tallies.
  • Frequency Percent: The frequency divided by the total of all tallied values.
  • Cumulative Frequency Percent: The cumulative frequency divided by the total of all tallied values.
  • Frequency Net Percent: The frequency divided by the total of all non-blank tallied values.
  • Cumulative Frequency Net Percent: The cumulative frequency divided by the total of all non-blank tallied values.
Based on the frequency generation settings, sometimes the value and label columns will be combined. The net percent columns will be suppressed If no non-blank values are tallied or if the nonetpercents command is used.