variables worksheet

Source: vignettes/variables_sheet.Rmd

Introduction

The variables worksheet acts as a reference sheet your project(s), by listing the variables you are using.

This vignette describes how the variables worksheet is organized and how to find variables that you can transform. The How to guides provides examples of how to use the this.

Read the variables worksheet

#> There are 24 variables, grouped in 21 sections and 8 subjects that are available for transformation.
#> You can search for variables in the table below. Try searching for the lab tests. There are 10 variables are in the lab test subject. 
#>     
#>     Try sorting the subject column by clicking the up beside the `subject` heading: the top 10 rows of the table should show the lab tests variables:
#> [1] "c(\"albumin\", \"alk.phos\", \"ast\", \"bili\", \"chol\", \"copper\", \"platelet\", \"protime\", \"stage\", \"trig\")"

How the variables.csv sheet is organized

There are 8 columns in this worksheet as follows:

  1. variable: the name of the final transformed variable.

  2. label: the shorthand label for the variable.

  3. labelLong: a more detailed label for the variable.

  4. section: the section where this variable could be found (i.e. demographic, lab test).

  5. subject: what the variable pertains to (i.e. age, sex, cholestral concentration).

  6. variableType: whether the final variable is categorical or continuous.

  7. units: any units for the final variable.

  8. databaseStart: the list of databases that contain the variable of interest

  9. variableStart: the original names of the variables as they are listed in each respective database

Derived Variables

Derived variables follow the same naming conventions as recoded variables when listed in variables worksheet.