R Under development (unstable) (2026-02-10 r89394 ucrt) -- "Unsuffered Consequences" Copyright (C) 2026 The R Foundation for Statistical Computing Platform: x86_64-w64-mingw32/x64 R is free software and comes with ABSOLUTELY NO WARRANTY. You are welcome to redistribute it under certain conditions. Type 'license()' or 'licence()' for distribution details. R is a collaborative project with many contributors. Type 'contributors()' for more information and 'citation()' on how to cite R or R packages in publications. Type 'demo()' for some demos, 'help()' for on-line help, or 'help.start()' for an HTML browser interface to help. Type 'q()' to quit R. > # This file is part of the standard setup for testthat. > # It is recommended that you do not modify it. > # > # Where should you do additional test configuration? > # Learn more about the roles of various files in: > # * https://r-pkgs.org/testing-design.html#sec-tests-files-overview > # * https://testthat.r-lib.org/articles/special-files.html > > library(testthat) > library(qol) The qol-package brings powerful concepts from 'SAS' to 'R' to make life easier and produce bigger and more complex outputs in less time with less code. Current version: 1.2.1 -> Use ?qol to get an overview. -> To view the changelog type: 'qol_news()' > > test_check("qol") > Computing stats > Rearranging data for output table > Formatting tables + year = 2024 + year = 2025 - - - 'any_table' execution time: 1.401 seconds - - - 'discrete_format' execution time: 0.001 seconds - - - 'discrete_format' execution time: 0.001 seconds > Computing stats > Rearranging data for output table > Formatting tables - - - 'any_table' execution time: 0.427 seconds > Computing stats > Rearranging data for output table > Formatting tables - - - 'any_table' execution time: 0.422 seconds > Computing stats > Rearranging data for output table > Formatting tables - - - 'any_table' execution time: 0.423 seconds ! WARNING: 'test' is invalid and will be omitted. > Computing stats > Rearranging data for output table > Formatting tables - - - 'any_table' execution time: 0.428 seconds > Formatting tables + tab1 + tab2 - - - 'combine_into_workbook' execution time: 1.677 seconds > Computing stats > Rearranging data for output table > Formatting tables - - - 'any_table' execution time: 0.181 seconds > Computing stats > Rearranging data for output table > Formatting tables - - - 'any_table' execution time: 0.174 seconds > Computing stats > Rearranging data for output table > Formatting tables - - - 'any_table' execution time: 0.424 seconds > Computing stats > Rearranging data for output table > Computing stats > Rearranging data for output table > Formatting tables - - - 'any_table' execution time: 0.48 seconds > Computing stats ! WARNING: Variable 'Test2' not found in the data frame. > Rearranging data for output table > Formatting tables - - - 'any_table' execution time: 0.507 seconds > Computing stats > Rearranging data for output table X ERROR: No files found in directory: D:/temp/2026_02_11_09_50_16_19862/RtmpOEr7JI > Write folder structure > Write all scripts execution > Write script execution > Putting together master file - - - 'build_master' execution time: 0.002 seconds - - - 'build_rstheme' execution time: 0.005 seconds > Collecting global information > Collecting per variable information + Number of unique values + Number of missing values + Longest value + Min and max value + Top value #################################################################################################### DATA FRAME CONTENT REPORT #################################################################################################### Data frame : dummy_df Type : data.table Observations : 10 Variables : 11 Memory Usage : 4.1 Kb Duplicate Vars : 0 Duplicate Rows : 0 --- Variable Type Counts --- character double integer 1 3 7 --- Variable Details --- pos name type unique na_count na_pct longest min_val max_val 1 1 year integer 1 0 0 4 2024 2024 2 2 household_id integer 4 0 0 1 1 4 3 3 person_id integer 4 0 0 1 1 4 4 4 first_person integer 2 0 0 1 0 1 5 5 state integer 3 0 0 1 3 8 6 6 sex integer 2 0 0 1 1 2 7 7 age integer 9 1 10 2 8 62 8 8 education character 4 1 10 6 high middle 9 9 income double 6 1 10 23 0 4732.95151 10 10 probability double 6 0 0 22 0 1 11 11 weight double 4 0 0 22 0.20654 0.32953 top_freq 1 2024 (100.0%) 2 3 ( 40.0%) 3 1 ( 40.0%) 4 0 ( 60.0%) 5 5 ( 60.0%) 6 1 ( 50.0%) 7 16 ( 20.0%) 8 low ( 40.0%) 9 0 ( 50.0%) 10 0 ( 40.0%) 11 0.233 ( 40.0%) - - - 'content_report' execution time: 0.021 seconds - - - 'expand_formats' execution time: 0.001 seconds - - - 'expand_formats' execution time: 0.001 seconds > Computing stats. - - - 'running_number' execution time: 0 seconds > Formatting tables. - - - 'crosstabs' execution time: 0.084 seconds > Computing stats. - - - 'running_number' execution time: 0 seconds > Formatting tables. - - - 'crosstabs' execution time: 0.163 seconds > Computing stats. - - - 'running_number' execution time: 0 seconds > Formatting tables. - - - 'crosstabs' execution time: 0.301 seconds > Computing stats. - - - 'running_number' execution time: 0 seconds > Formatting tables. - - - 'crosstabs' execution time: 0.552 seconds > Computing stats. - - - 'running_number' execution time: 0 seconds > Formatting tables. - - - 'crosstabs' execution time: 0.406 seconds > Computing stats. - - - 'running_number' execution time: 0 seconds > Formatting tables. + year = 2024 + year = 2025 - - - 'crosstabs' execution time: 0.694 seconds > Computing stats. - - - 'running_number' execution time: 0 seconds > Formatting tables. - - - 'crosstabs' execution time: 0.09 seconds > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.013 seconds > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.012 seconds - - - 'free_memory' removed 2 object(s) and freed approximately 168 bytes. > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.01 seconds > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.01 seconds - - - 'free_memory' removed 2 object(s) and freed approximately 112 bytes. > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.01 seconds > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.009 seconds - - - 'free_memory' removed 1 object(s) and freed approximately 56 bytes. > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.009 seconds > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.009 seconds > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.009 seconds > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.009 seconds > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.009 seconds > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.009 seconds - - - 'free_memory' removed 2 object(s) and freed approximately 112 bytes. - - - 'free_memory' removed 2 object(s) and freed approximately 8.2 Kb. - - - 'free_memory' removed 3 object(s) and freed approximately 8.3 Kb. > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.01 seconds > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.01 seconds > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.01 seconds > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.01 seconds > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.011 seconds > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.011 seconds > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.01 seconds > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.01 seconds > Computing stats. > Formatting tables. - - - 'frequencies' execution time: 0.079 seconds > Computing stats. > Formatting tables. - - - 'frequencies' execution time: 0.054 seconds > Computing stats. > Formatting tables. - - - 'frequencies' execution time: 0.057 seconds ! WARNING: Type mismatch: Current value 2 is of type double but should be of type character. age_group will be converted to character. - - - 'if.' removed 526 observations. Data frame now has 474 observations. - - - 'if.' removed 60 observations. Data frame now has 940 observations. - - - 'if.' removed 60 observations. Data frame now has 940 observations. ! WARNING: The provided variable 'test' is not part of the data frame. This variable will be omitted during computation. - - - 'if.' removed 0 observations. Data frame now has 1.000 observations. - - - 'if.' removed 0 observations. Data frame now has 1.000 observations. - - - 'if.' removed 526 observations. Data frame now has 474 observations. > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.009 seconds > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.009 seconds > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.008 seconds - - - 'export_data' execution time: 0.002 seconds - - - 'export_data' execution time: 0.101 seconds - - - 'export_data' execution time: 0.009 seconds - - - 'export_data' execution time: 0.004 seconds - - - 'export_data' execution time: 0.004 seconds - - - 'export_data' execution time: 0.004 seconds - - - 'export_data' execution time: 0.004 seconds - - - 'export_data' execution time: 0.004 seconds - - - 'export_data' execution time: 0.004 seconds - - - 'export_multi' execution time: 0.002 seconds - - - 'export_multi' execution time: 0.19 seconds - - - 'export_multi' execution time: 0.122 seconds - - - 'import_data' execution time: 0.002 seconds - - - 'import_data' execution time: 0.001 seconds - - - 'import_data' execution time: 0.053 seconds - - - 'import_data' execution time: 0.034 seconds - - - 'import_data' execution time: 0.051 seconds - - - 'import_data' execution time: 0.047 seconds - - - 'import_data' execution time: 0.005 seconds - - - 'import_data' execution time: 0.004 seconds - - - 'import_data' execution time: 0.004 seconds - - - 'import_data' execution time: 0.005 seconds - - - 'import_data' execution time: 0.004 seconds ! WARNING: Only one character element allowed for region. The whole file will be read. - - - 'import_data' execution time: 0.051 seconds - - - 'import_data' execution time: 0.05 seconds - - - 'import_data' execution time: 0.094 seconds - - - 'import_multi' execution time: 0.06 seconds - - - 'import_multi' execution time: 0.152 seconds - - - 'set' execution time: 0 seconds - - - 'set' execution time: 0.001 seconds - - - 'set' execution time: 0 seconds + qol_example_data_csv.csv + qol_example_data_xlsx.xlsx ! WARNING: The provided join method 'test' is not valid. > Begin joining. + left joining data_frame 2 to base data frame. - - - 'multi_join' execution time: 0.012 seconds > Begin joining. + left joining data_frame 2 to base data frame. - - - 'multi_join' execution time: 0.012 seconds > Begin joining. + left joining data_frame 2 to base data frame. ! WARNING: Formats not passed correctly. Create format object first and then pass it to the function parameter like: list(my_variable = my_format) ! WARNING: Formats not passed correctly. Create format object first and then pass it to the function parameter like: list(my_variable = my_format) - - - 'recode' execution time: 0.006 seconds - - - 'recode' execution time: 0 seconds - - - 'recode_multi' execution time: 0.001 seconds - - - 'recode_multi' execution time: 0.006 seconds - - - 'recode_multi' execution time: 0.008 seconds - - - 'rename_multi' execution time: 0 seconds > Generating dummy file. Computing ... + years + households and states + weights + age + income + probability + sex > Putting data together - - - 'dummy_data' execution time: 0.009 seconds - - - 'running_number' execution time: 0.004 seconds - - - 'mark_cases' execution time: 0.004 seconds - - - 'mark_cases' execution time: 0.004 seconds ! WARNING: The provided variable '' is not part of the data frame. This variable will be omitted during computation. ! WARNING: The provided variable '' is not part of the data frame. This variable will be omitted during computation. ! WARNING: 'from' variable 'status1' is not part of the data frame. Selection will start from the first variable. ! WARNING: 'to' variable 'age3' is not part of the data frame. Selection will go until the last variable. - - - 'retain_variables' execution time: 0.004 seconds ! WARNING: Variable is not an integer and will be floored. Decimal places won't count. X ERROR: No valid variable provided. Sorting will be aborted. X ERROR: No valid variable provided. Sorting will be aborted. - - - 'sort_plus' execution time: 0.004 seconds > Preparing formats - - - 'sort_plus' execution time: 0.006 seconds > Preparing formats - - - 'sort_plus' execution time: 0.006 seconds > Preparing formats - - - 'sort_plus' execution time: 0.006 seconds ! WARNING: The provided variable 'var3' is not part of the data frame. This variable will be omitted during computation. > Executing nested merge - - - 'summarise_plus' execution time: 0.014 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.019 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.015 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.015 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.015 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.015 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.015 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.015 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.017 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.017 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.017 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.017 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.019 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.024 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.018 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.02 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.02 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.02 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.019 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.019 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.025 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.021 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.021 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.023 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.021 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.019 seconds > Executing nested merge ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 - - - 'summarise_plus' execution time: 0.017 seconds > Executing nested merge ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 - - - 'summarise_plus' execution time: 0.016 seconds > Executing nested merge ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 - - - 'summarise_plus' execution time: 0.017 seconds > Executing nested merge ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 - - - 'summarise_plus' execution time: 0.016 seconds > Executing nested merge ~ NOTE: 44 missings generated from grouping variables (4.9 %). Number of observations: 857/901 - - - 'summarise_plus' execution time: 0.057 seconds > Executing nested merge ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 - - - 'summarise_plus' execution time: 0.016 seconds > Executing nested merge ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 - - - 'summarise_plus' execution time: 0.016 seconds ! WARNING: 'test' is invalid and will be omitted. > Executing nested merge ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 - - - 'summarise_plus' execution time: 0.015 seconds > Executing nested merge ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 > Merging back - - - 'summarise_plus' execution time: 0.016 seconds > Executing merge: + total > Executing combination merge: + year + sex ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 > Putting results together - - - 'summarise_plus' execution time: 0.025 seconds > Executing merge: + total > Executing combination merge: + year + sex ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 > Putting results together - - - 'summarise_plus' execution time: 0.026 seconds > Executing merge: + total > Executing combination merge: + year + sex ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 + age ~ NOTE: 53 missings generated from grouping variables (5.3 %). Number of observations: 947/1.000 + education ~ NOTE: 49 missings generated from grouping variables (4.9 %). Number of observations: 951/1.000 + year + sex ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 + year + age ~ NOTE: 53 missings generated from grouping variables (5.3 %). Number of observations: 947/1.000 + year + education ~ NOTE: 49 missings generated from grouping variables (4.9 %). Number of observations: 951/1.000 + sex + age ~ NOTE: 98 missings generated from grouping variables (9.8 %). Number of observations: 902/1.000 + sex + education ~ NOTE: 96 missings generated from grouping variables (9.6 %). Number of observations: 904/1.000 + age + education ~ NOTE: 99 missings generated from grouping variables (9.9 %). Number of observations: 901/1.000 + year + sex + age ~ NOTE: 98 missings generated from grouping variables (9.8 %). Number of observations: 902/1.000 + year + sex + education ~ NOTE: 96 missings generated from grouping variables (9.6 %). Number of observations: 904/1.000 + year + age + education ~ NOTE: 99 missings generated from grouping variables (9.9 %). Number of observations: 901/1.000 + sex + age + education ~ NOTE: 143 missings generated from grouping variables (14.3 %). Number of observations: 857/1.000 + year + sex + age + education ~ NOTE: 143 missings generated from grouping variables (14.3 %). Number of observations: 857/1.000 > Putting results together - - - 'summarise_plus' execution time: 0.276 seconds > Executing merge: + total > Executing combination merge: + age ~ NOTE: 53 missings generated from grouping variables (5.3 %). Number of observations: 947/1.000 + year + sex ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 + sex + age ~ NOTE: 98 missings generated from grouping variables (9.8 %). Number of observations: 902/1.000 > Putting results together - - - 'summarise_plus' execution time: 0.1 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.014 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.018 seconds > Executing nested merge ~ NOTE: 98 missings generated from grouping variables (9.8 %). Number of observations: 902/1.000 - - - 'summarise_plus' execution time: 0.017 seconds > Executing nested merge ~ NOTE: 98 missings generated from grouping variables (9.8 %). Number of observations: 902/1.000 - - - 'summarise_plus' execution time: 0.015 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.015 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.014 seconds > Executing nested merge ~ NOTE: 99 missings generated from grouping variables (9.9 %). Number of observations: 901/1.000 - - - 'summarise_plus' execution time: 0.023 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.018 seconds - - - 'if.' removed 614 observations. Data frame now has 386 observations. > Executing nested merge - - - 'summarise_plus' execution time: 0.019 seconds - - - 'if.' removed 614 observations. Data frame now has 386 observations. > Executing merge: + total > Executing combination merge: + year + sex + age + year + sex + year + age + sex + age + year + sex + age > Putting results together - - - 'summarise_plus' execution time: 0.066 seconds > Executing nested merge ~ NOTE: 53 missings generated from grouping variables (5.3 %). Number of observations: 947/1.000 - - - 'summarise_plus' execution time: 0.017 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.02 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.02 seconds > Executing nested merge ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 ! WARNING: To calculate percentiles there may be no NAs in the value variables. - - - 'summarise_plus' execution time: 0.023 seconds ! WARNING: 'p101' is invalid and will be omitted. ! WARNING: No valid selected. 'sum' will be used. > Executing nested merge ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 - - - 'summarise_plus' execution time: 0.019 seconds > Executing nested merge ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 - - - 'summarise_plus' execution time: 0.019 seconds > Executing nested merge ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 - - - 'summarise_plus' execution time: 0.024 seconds > Executing nested merge ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 - - - 'summarise_plus' execution time: 0.019 seconds > Executing nested merge ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 - - - 'summarise_plus' execution time: 0.019 seconds > Executing nested merge ~ NOTE: 98 missings generated from grouping variables (9.8 %). Number of observations: 902/1.000 - - - 'summarise_plus' execution time: 0.02 seconds > Executing nested merge ~ NOTE: 48 missings generated from grouping variables (4.8 %). Number of observations: 952/1.000 > Merging back - - - 'summarise_plus' execution time: 0.026 seconds > Executing nested merge - - - 'summarise_plus' execution time: 0.018 seconds ! WARNING: 'test' is invalid and will be omitted. > Executing nested merge - - - 'summarise_plus' execution time: 0.018 seconds [1] 4 [1] 4 [1] 4 [1] 4 [1] 4 [1] 4 [1] 4 [1] 4 ! WARNING: may only be of length one. The first Element will be used. [1] 4 > Transposing wide to long + sex = Male - - - 'transpose_plus' execution time: 0.008 seconds ! WARNING: may only be of length one. The first Element will be used. [1] 4 > Transposing wide to long + sex = Male - - - 'transpose_plus' execution time: 0.007 seconds [1] 4 > Transposing long to wide. + sex - - - 'transpose_plus' execution time: 0.008 seconds [1] 4 X ERROR: No variables provided. Summarise will be aborted. [1] 4 [1] 4 [1] 4 [1] 4 > Transposing long to wide. + sex + education [ FAIL 0 | WARN 0 | SKIP 0 | PASS 829 ] > > proc.time() user system elapsed 66.95 2.71 70.48