Approximate the output from SAS's PROC FREQ procedure when using the /list option of the TABLE statement.
freqlist(object, ...)
# S3 method for class 'table'
freqlist(
object,
na.options = c("include", "showexclude", "remove"),
strata = NULL,
labelTranslations = NULL,
control = NULL,
...
)
# S3 method for class 'formula'
freqlist(
formula,
data,
subset,
na.action,
na.options = c("include", "showexclude", "remove"),
strata = NULL,
labelTranslations = NULL,
control = NULL,
addNA,
exclude,
drop.unused.levels,
...
)An R object, usually of class "table" or class "xtabs"
additional arguments. In the formula method, these are passed to the table method. These are also passed to
freq.control
a character string indicating how to handling missing values: "include"
(include values with NAs in counts and percentages),
"showexclude" (show NAs but exclude from cumulative counts and all percentages),
"remove" (remove values with NAs); default is "include".
(formerly groupBy) an optional character string specifying a variable(s) to use for grouping when calculating cumulative
counts and percentages. summary.freqlist will also separate by grouping variable for printing. Note that this is different
from modelsum and tableby, which take bare column names (and only one, at that!)
an optional character string (or list) of labels to use for variable levels when summarizing. Names will be matched appropriately.
control parameters to handle optional settings within freqlist. See freq.control
Arguments passed to xtabs.
An object of class c("freqlist", "arsenal_table")
# load mockstudy data
data(mockstudy)
tab.ex <- table(mockstudy[c("arm", "sex", "mdquality.s")], useNA = "ifany")
noby <- freqlist(tab.ex, na.options = "include")
summary(noby)
#>
#>
#> |arm |sex |mdquality.s | Freq| Cumulative Freq| Percent| Cumulative Percent|
#> |:---------|:------|:-----------|----:|---------------:|-------:|------------------:|
#> |A: IFL |Male |0 | 29| 29| 1.93| 1.93|
#> | | |1 | 214| 243| 14.28| 16.21|
#> | | |NA | 34| 277| 2.27| 18.48|
#> | |Female |0 | 12| 289| 0.80| 19.28|
#> | | |1 | 118| 407| 7.87| 27.15|
#> | | |NA | 21| 428| 1.40| 28.55|
#> |F: FOLFOX |Male |0 | 31| 459| 2.07| 30.62|
#> | | |1 | 285| 744| 19.01| 49.63|
#> | | |NA | 95| 839| 6.34| 55.97|
#> | |Female |0 | 21| 860| 1.40| 57.37|
#> | | |1 | 198| 1058| 13.21| 70.58|
#> | | |NA | 61| 1119| 4.07| 74.65|
#> |G: IROX |Male |0 | 17| 1136| 1.13| 75.78|
#> | | |1 | 187| 1323| 12.47| 88.26|
#> | | |NA | 24| 1347| 1.60| 89.86|
#> | |Female |0 | 14| 1361| 0.93| 90.79|
#> | | |1 | 121| 1482| 8.07| 98.87|
#> | | |NA | 17| 1499| 1.13| 100.00|
#>
# show the top 6 rows' frequencies and percents
head(summary(sort(noby, decreasing = TRUE)[c(1:4, 6)]))
#>
#>
#> |arm |sex |mdquality.s | Freq| Percent|
#> |:---------|:------|:-----------|----:|-------:|
#> |F: FOLFOX |Male |1 | 285| 19.01|
#> |A: IFL |Male |1 | 214| 14.28|
#> |F: FOLFOX |Female |1 | 198| 13.21|
#> |G: IROX |Male |1 | 187| 12.47|
#> | |Female |1 | 121| 8.07|
#> |A: IFL |Female |1 | 118| 7.87|
#>
withby <- freqlist(tab.ex, strata = c("arm","sex"), na.options = "showexclude")
summary(withby)
#>
#>
#> |arm |sex |mdquality.s | Freq| Cumulative Freq| Percent| Cumulative Percent|
#> |:------|:----|:-----------|----:|---------------:|-------:|------------------:|
#> |A: IFL |Male |0 | 29| 29| 11.93| 11.93|
#> | | |1 | 214| 243| 88.07| 100.00|
#> | | |NA | 34| NA| NA| NA|
#>
#>
#> |arm |sex |mdquality.s | Freq| Cumulative Freq| Percent| Cumulative Percent|
#> |:------|:------|:-----------|----:|---------------:|-------:|------------------:|
#> |A: IFL |Female |0 | 12| 12| 9.23| 9.23|
#> | | |1 | 118| 130| 90.77| 100.00|
#> | | |NA | 21| NA| NA| NA|
#>
#>
#> |arm |sex |mdquality.s | Freq| Cumulative Freq| Percent| Cumulative Percent|
#> |:---------|:----|:-----------|----:|---------------:|-------:|------------------:|
#> |F: FOLFOX |Male |0 | 31| 31| 9.81| 9.81|
#> | | |1 | 285| 316| 90.19| 100.00|
#> | | |NA | 95| NA| NA| NA|
#>
#>
#> |arm |sex |mdquality.s | Freq| Cumulative Freq| Percent| Cumulative Percent|
#> |:---------|:------|:-----------|----:|---------------:|-------:|------------------:|
#> |F: FOLFOX |Female |0 | 21| 21| 9.59| 9.59|
#> | | |1 | 198| 219| 90.41| 100.00|
#> | | |NA | 61| NA| NA| NA|
#>
#>
#> |arm |sex |mdquality.s | Freq| Cumulative Freq| Percent| Cumulative Percent|
#> |:-------|:----|:-----------|----:|---------------:|-------:|------------------:|
#> |G: IROX |Male |0 | 17| 17| 8.33| 8.33|
#> | | |1 | 187| 204| 91.67| 100.00|
#> | | |NA | 24| NA| NA| NA|
#>
#>
#> |arm |sex |mdquality.s | Freq| Cumulative Freq| Percent| Cumulative Percent|
#> |:-------|:------|:-----------|----:|---------------:|-------:|------------------:|
#> |G: IROX |Female |0 | 14| 14| 10.37| 10.37|
#> | | |1 | 121| 135| 89.63| 100.00|
#> | | |NA | 17| NA| NA| NA|
#>