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.
CSPro can write frequency tables in several formats. CSPro will save tables in a format based on the extension of the frequencies filename.
Format | Extension | Results Viewer |
Table | .tbw | Table Viewer |
Text | .lst | Text Viewer |
HTML | .html / .htm | Default Internet browser |
JSON | .json | Default JSON viewer |
Excel | .xlsx | Microsoft 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.
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.