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 and HTML listing files support the saving of frequencies.
CSPro can write frequency tables in four formats. CSPro will save tables in a format based on the extension of the frequencies filename.
|HTML||.html / .htm||Default Internet browser|
|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.