I hereby claim:
- I am jasonpott on github.
- I am jasonpott (https://keybase.io/jasonpott) on keybase.
- I have a public key ASCNKIOjnU7M_9r4ICOHtKm4ZxepagvnjllEqCJeDMW5Fwo To claim this, I am signing this object:
{
"body": {
"key": {
jasonpott
/ keybase.md
Created
November 8, 2022 21:38
jasonpott
/ purrr_map_multiple_event_extract.R
Created
December 10, 2021 20:11
Method to extract sequential events for a defined population in MS SQL via dbplyr / purrr / R
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # con is a connection object | |
| #Package load | |
| pacman::p_load(tidyverse, tidylog, janitor, pool,odbc, dbplyr) | |
| dbConnect( | |
| odbc(), | |
| Driver = "SQL Server", | |
| Server = "server name", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| cat( | |
| "# History files", | |
| ".Rhistory", | |
| ".Rapp.history", | |
| "# Session Data files", | |
| ".RData", | |
| "# User-specific files", | |
| ".Ruserdata", | |
| "# Example code in package build process", |