Skip to contents

Convert Blank Strings Into NAs

Source: R/user_utils.R
convert_blanks_to_na.Rd

Turn SAS blank strings into proper R NAs.

Usage

convert_blanks_to_na(x)

# Default S3 method
convert_blanks_to_na(x)

# S3 method for class 'character'
convert_blanks_to_na(x)

# S3 method for class 'list'
convert_blanks_to_na(x)

# S3 method for class 'data.frame'
convert_blanks_to_na(x)

Arguments

x

Any R object

Default value

none

Value

An object of the same class as the input

Details

The default methods simply returns its input unchanged. The character method turns every instance of "" into NA_character_ while preserving all attributes. When given a data frame as input the function keeps all non-character columns as is and applies the just described logic to character columns. Once again all attributes such as labels are preserved.

See also

Utilities for Formatting Observations: convert_na_to_blanks(), yn_to_numeric()

Examples

library(tibble)

convert_blanks_to_na(c("a", "b", "", "d", ""))
#> [1] "a" "b" NA  "d" NA 

df <- tribble(
  ~USUBJID,   ~RFICDTC,
  "1001", "2000-01-01",
  "1002", "2001-01-01",
  "1003",           ""
)
print(df)
#> # A tibble: 3 × 2
#>   USUBJID RFICDTC     
#>   <chr>   <chr>       
#> 1 1001    "2000-01-01"
#> 2 1002    "2001-01-01"
#> 3 1003    ""          
convert_blanks_to_na(df)
#> # A tibble: 3 × 2
#>   USUBJID RFICDTC   
#>   <chr>   <chr>     
#> 1 1001    2000-01-01
#> 2 1002    2001-01-01
#> 3 1003    NA