Other packages > Find by keyword >

sqlcaser  

'SQL' Case Statement Generator
View on CRAN: Click here


Download and install sqlcaser package within the R console
Install from CRAN:
install.packages("sqlcaser")

Install from Github:
library("remotes")
install_github("cran/sqlcaser")

Install by package version:
library("remotes")
install_version("sqlcaser", "0.2.1")



Attach the package and use:
library("sqlcaser")
Maintained by
Leoson Hoay
[Scholar Profile | Author Map]
All associated links for this package
First Published: 2023-11-24
Latest Update: 2023-11-24
Description:
Includes built-in methods for generating long 'SQL' CASE statements, and other 'SQL' statements that may otherwise be arduous to construct by hand. The generated statement can easily be concatenated to string literals to form queries to 'SQL'-like databases, such as when using the 'RODBC' package. The current methods include casewhen() for building CASE statements, inlist() for building IN statements, and updatetable() for building UPDATE statements.
How to cite:
Leoson Hoay (2023). sqlcaser: 'SQL' Case Statement Generator. R package version 0.2.1, https://cran.r-project.org/web/packages/sqlcaser. Accessed 01 Nov. 2026.
Previous versions and publish date:
(2026-07-09 07:08), 0.2.0 (2023-11-24 14:20)
Other packages that cited sqlcaser R package
View sqlcaser citation profile
Other R packages that sqlcaser depends, imports, suggests or enhances
Complete documentation for sqlcaser
Functions, R codes and Examples using the sqlcaser R package
Some associated functions: casewhen . inlist . updatetable . 
Some associated R codes: casewhen.R . inlist.R . updatetable.R .  Full sqlcaser package functions and examples
Downloads during the last 30 days

Today's Hot Picks in Authors and Packages

tictoc  
Functions for Timing R Scripts, as Well as Implementations of "Stack" and "StackList" Structures
Code execution timing functions 'tic' and 'toc' that can be nested. One can record all timings while ...
Download / Learn more Package Citations See dependency  
RankResponse  
Ranking Responses in a Single Response Question or a Multiple Response Question
Methods for ranking responses of a single response question or a multiple response question are des ...
Download / Learn more Package Citations See dependency  
bigtime  
Sparse Estimation of Large Time Series Models
Estimation of large Vector AutoRegressive (VAR), Vector AutoRegressive with Exogenous Variables X (V ...
Download / Learn more Package Citations See dependency  
quantspec  
Quantile-Based Spectral Analysis of Time Series
Methods to determine, smooth and plot quantile periodograms for univariate and multivariate time se ...
Download / Learn more Package Citations See dependency  
nextGenShinyApps  
Craft Exceptional 'R Shiny' Applications and Dashboards with Novel Responsive Tools
Nove responsive tools for designing and developing 'Shiny' dashboards and applications. The scripts ...
Download / Learn more Package Citations See dependency  
jack  
Jack, Zonal, Schur, and Other Symmetric Polynomials
Symbolic calculation and evaluation of the Jack polynomials, zonal polynomials, and Schur polynomia ...
Download / Learn more Package Citations See dependency  

29,315

R Packages

247,686

Dependencies

77,531

Author Associations

29,316

Publication Badges

© Copyright since 2022. All right reserved, rpkg.net.  Based in Cambridge, Massachusetts, USA