Displaying 1 result from an estimated 1 matches for "natcollect".
Did you mean:
a_collect
2012 Jan 10
1
Extracting Data from SQL Server
...s which i want to evaluate against a list of particular
codes (CVD_ICD$ table). Given the size of the patient table I want to
restrict the data I pull into R to the data I only want to analyse so I am
using SQL to do this. The code i have is as follows:
library(RODBC)
channel<-odbcConnect("NatCollections")
query<-"SELECT UNIQUE_ID, diag01 from LoadPUS
WHERE (diag01 IN (SELECT [ICD-10 Codes] From CVD_ICD10$)) OR (diag02 IN
(SELECT [ICD-10 Codes] From CVD_ICD10$))
OR (diag03 IN (SELECT [ICD-10 Codes] From CVD_ICD10$))"
This returns duplicate values, I don't want to hardcod...