Talk to the Veterans Crisis Line now
U.S. flag
An official website of the United States government

VA Health Systems Research

Go to the VA ORD website
Go to the QUERI website

VA Informatics and Computing Infrastructure

Efficiently Accessing VINCI Data in R

by Andrew Redd, PhD
Seminar date: 9/10/2020

Description: Andrew Redd, VINCI Helpdesk Staff, will present methods for efficiently working with data within VINCI. This presentation will cover establishing connections to MSSQL servers; merging, filtering, cleaning, and aggregating data on the servers; pulling data into R for analysis and pushing data back to database servers. The presentation will focus around the dplyr and dbplyr packages for R. Intended Audience: Any R Programmer, Familiarity with R will be assumed.

DOWNLOAD: PDF handout | Audio only (mp3) | transcript

Questions about the HSR website? Email the Web Team

Any health information on this website is strictly for informational purposes and is not intended as medical advice. It should not be used to diagnose or treat any condition.