File:Fig1 Ye JofPathInformatics2016 7.jpg

Figure 1. R code for retrieving data from database and for performing preliminary data element extraction. Lines start with hash mark are comment lines, not executed by R interpreter. The content of the connection string in line conn <- odbcDriverConnect("driver={SQL Server}; SERVER = 192.168.*.***,****; DATABASE = Pathology_ Database; UID = Jay_Ye; PWD = Open_Sesame") is modified for confidentiality. Twenty-nine (29) lines of code for selecting out synoptic reports corresponding to unique lesions are omitted. See Materials and Methods for additional description.

Ye, J.J. (2016). "Pathology report data extraction from relational database using R, with extraction from reports on melanoma of skin as an example". Journal of Pathology Informatics 7: 44. doi:10.4103/2153-3539.192822. 

2016

Ye, J.J.

Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported