checkVarNames: Check names for 'SQLite' column name conventions.

In eatGADS: Data Management of Large Hierarchical Data

Check names for SQLite column name conventions.

Description

Checks names for SQLite column name conventions and applies appropriate variable name changes to GADSdat or all_GADSdat objects.

Usage

checkVarNames(
  GADSdat,
  checkKeywords = TRUE,
  checkDots = TRUE,
  checkDuplicates = TRUE
)

Arguments

GADSdat	GADSdat or all_GADSdat object.
checkKeywords	Logical. Should SQLite keywords be checked and modified?
checkDots	Logical. Should occurrences of "." be checked and modified?
checkDuplicates	Logical. Should case insensitive duplicate variable names be checked and modified?

Details

Invalid column names in a SQLite data base include

• SQLite keywords (see sqlite_keywords),

• column names with a "." in it and

• duplicate variable names which arise from SQLite being case insensitive.

The corresponding variable name changes are

• appending the suffix "Var" to all SQLite keywords,

• changing all "." in variable names to "_" and

• appending "_2" to case insensitive duplicated variable names.

Note that avoiding "." in variable names is beneficial for multiple reasons, such as avoiding confusion with S3 methods in R and issues when importing from Stata.

Value

Returns the original object with updated variable names.

Examples

# Change example data set (create an invalid variable name)
pisa2 <- changeVarNames(pisa, oldNames = "computer_age",
                        newNames = "computer.age")

pisa3 <- checkVarNames(pisa2)

eatGADS documentation built on June 8, 2025, 12:42 p.m.