Displaying 1 result from an estimated 1 matches for "cvd_icd10".
2012 Jan 10
1
Extracting Data from SQL Server
...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 hardcode the values because
it is quite a long list. Running the "IN" function just for "diag01" returns
the...