IALSA / ialsa-2016-groningen

Maelstrom Harmonization Workshop. Assessing the impact of different harmonization procedures on the analysis results from several real datasets.
GNU General Public License v2.0
1 stars 0 forks source link

Harmonization: SMOKING #2

Open andkov opened 8 years ago

andkov commented 8 years ago

Accounting for the smoking measure in the participating studies.

andkov commented 8 years ago

LBLS

image

currently (2016-03-25) included into the exercise file are

image

andkov commented 8 years ago

SATSA

image

currently (2016-03-25) included into the exercise file are

image

andkov commented 8 years ago

SHARE

image image

currently (2016-03-25) included into the exercise file are

image

andkov commented 8 years ago

TILDA

image

currently (2016-03-25) included into exercise file

image

andkov commented 8 years ago

ALSA

image

currently (2016-03-25) included into the exercise file are

image

andkov commented 8 years ago

The variables from the raw files had the names

study_name SMOKER PIPCIGAR SMK94 SMOKE GEVRSMK GEVRSNS GSMOKNOW BR0010 BR0020 BR0030

and the following allocation across studies

study_name :        
        alsa lbsl satsa share tilda
  alsa  2087 .    .     .     .    
  lbsl  .    656  .     .     .    
  satsa .    .    1497  .     .    
  share .    .    .     2598  .    
  tilda .    .    .     .     8504 

SMOKER : Smoker     
      alsa lbsl satsa share tilda
  Yes 176  .    .     .     .    
  No  1892 .    .     .     .    

PIPCIGAR : Smokes pipe or cigars     
      alsa lbsl satsa share tilda
  Yes 48   .    .     .     .    
  No  169  .    .     .     .    

SMK94 : Currently smoke?     
      alsa lbsl satsa share tilda
  no  .    483  .     .     .    
  yes .    74   .     .     .    

SMOKE : Smoke, tobacco use                                               
                                                alsa lbsl satsa share tilda
  smoke at present time                         .    74   .     .     .    
  don't smoke at present but smoked in the past .    283  .     .     .    
  never smoked                                  .    207  .     .     .    

GEVRSMK : Do you smoke cigarettes, cigars or a pipe? - Yes                         
                          alsa lbsl satsa share tilda
  Yes                     .    .    327   .     .    
  No, I have never smoked .    .    720   .     .    
  No, I quit.             .    .    369   .     .    

GEVRSNS : Do you take snuff? - Yes                              
                               alsa lbsl satsa share tilda
  Yes                          .    .    91    .     .    
  No, I have never taken snuff .    .    1254  .     .    
  No, I quit.                  .    .    59    .     .    

GSMOKNOW : Have you smoked more than 6 cigarettes, 4 cigars or used pipe tobacco or snuff during the last month?     
      alsa lbsl satsa share tilda
  No  .    .    183   .     .    
  Yes .    .    365   .     .    

BR0010 : ever smoked daily            
             alsa lbsl satsa share tilda
  yes        .    .    .     1052  .    
  no         .    .    .     1542  .    
  refusal    .    .    .     .     .    
  don't know .    .    .     .     .    

BR0020 : smoke at the present time                    
                     alsa lbsl satsa share tilda
  yes                .    .    .     408   .    
  no, i have stopped .    .    .     644   .    
  refusal            .    .    .     .     .    
  don't know         .    .    .     .     .    

BR0030 : how many years smoked      
       alsa lbsl satsa share tilda
  0    .    .    .     6     .    
  1    .    .    .     11    .    
  2    .    .    .     19    .    
  3    .    .    .     7     .    
  4    .    .    .     10    .    
  5    .    .    .     41    .    
  6    .    .    .     9     .    
  7    .    .    .     8     .    
  8    .    .    .     13    .    
  9    .    .    .     2     .    
  10   .    .    .     70    .    
  11   .    .    .     4     .    
  12   .    .    .     15    .    
  13   .    .    .     5     .    
  14   .    .    .     5     .    
  15   .    .    .     41    .    
  16   .    .    .     2     .    
  17   .    .    .     8     .    
  18   .    .    .     8     .    
  19   .    .    .     1     .    
  20   .    .    .     103   .    
  21   .    .    .     2     .    
  22   .    .    .     10    .    
  23   .    .    .     5     .    
  24   .    .    .     2     .    
  25   .    .    .     52    .    
  26   .    .    .     9     .    
  27   .    .    .     8     .    
  28   .    .    .     11    .    
  29   .    .    .     5     .    
  30   .    .    .     157   .    
  31   .    .    .     8     .    
  32   .    .    .     19    .    
  33   .    .    .     12    .    
  34   .    .    .     6     .    
  35   .    .    .     49    .    
  36   .    .    .     14    .    
  37   .    .    .     11    .    
  38   .    .    .     11    .    
  39   .    .    .     5     .    
  40   .    .    .     118   .    
  41   .    .    .     7     .    
  42   .    .    .     2     .    
  43   .    .    .     5     .    
  44   .    .    .     6     .    
  45   .    .    .     24    .    
  46   .    .    .     4     .    
  47   .    .    .     2     .    
  48   .    .    .     4     .    
  50   .    .    .     47    .    
  51   .    .    .     1     .    
  52   .    .    .     1     .    
  53   .    .    .     1     .    
  54   .    .    .     6     .    
  55   .    .    .     6     .    
  56   .    .    .     2     .    
  57   .    .    .     3     .    
  58   .    .    .     1     .    
  60   .    .    .     12    .    
  61   .    .    .     2     .    
  63   .    .    .     1     .    
  65   .    .    .     1     .    
  67   .    .    .     1     .    
  70   .    .    .     1     .    
  9999 .    .    .     10    .    

BH001 : bh001  Have you ever smoked cigarettes, cigars, cigarillos or a pipe daily for a per?     
      alsa lbsl satsa share tilda
  Yes .    .    .     .     4777 
  No  .    .    .     .     3726 

BH002 : bh002  Do you smoke at the present time?                    
                     alsa lbsl satsa share tilda
  UNDOCUMENTED CODE  .    .    .     .     3727 
  Yes                .    .    .     .     1564 
  No, I have stopped .    .    .     .     3213 

BH003 : bh003  How old were you when you stopped smoking?    
     alsa lbsl satsa share tilda
  -1 .    .    .     .     5291 
  6  .    .    .     .     1    
  13 .    .    .     .     1    
  14 .    .    .     .     2    
  15 .    .    .     .     3    
. . . . . . . . . . . 
  84 .    .    .     .     2    
  85 .    .    .     .     1    

BEHSMOKER : BEHsmoker  Smoker         
          alsa lbsl satsa share tilda
  Never   .    .    .     .     3726 
  Past    .    .    .     .     3213 
  Current .    .    .     .     1564 
andkov commented 8 years ago

After renaming with the .xls map the variable names are

study_name, smoke_now, smoke_pipecigar,  smoke_history, 
 snuff_history, smoke_years, smoke_age, smoke_history2 

and the following allocation across studies

> t<-table(ds$smoke_now,ds$study_name);t[t=="0"]<-".";t

                     alsa lbsl satsa share tilda
  Yes                176  .    365   .     1564 
  No                 1892 .    183   .     .    
  no                 .    483  .     .     .    
  yes                .    74   .     408   .    
  no, i have stopped .    .    .     644   .    
  refusal            .    .    .     .     .    
  don't know         .    .    .     .     .    
  UNDOCUMENTED CODE  .    .    .     .     3727 
  No, I have stopped .    .    .     .     3213 
> t<-table(ds$smoke_pipecigar,ds$study_name);t[t=="0"]<-".";t

      alsa lbsl satsa share tilda
  Yes 48   .    .     .     .    
  No  169  .    .     .     .    
> t<-table(ds$smoke_history,ds$study_name);t[t=="0"]<-".";t

                                                alsa lbsl satsa share tilda
  smoke at present time                         .    74   .     .     .    
  don't smoke at present but smoked in the past .    283  .     .     .    
  never smoked                                  .    207  .     .     .    
  Yes                                           .    .    327   .     4777 
  No, I have never smoked                       .    .    720   .     .    
  No, I quit.                                   .    .    369   .     .    
  yes                                           .    .    .     1052  .    
  no                                            .    .    .     1542  .    
  refusal                                       .    .    .     .     .    
  don't know                                    .    .    .     .     .    
  No                                            .    .    .     .     3726 
> t<-table(ds$smoke_history2, ds$study_name);t[t=="0"]<-".";t

          alsa lbsl satsa share tilda
  Never   .    .    .     .     3726 
  Past    .    .    .     .     3213 
  Current .    .    .     .     1564 
> t<-table(ds$smoke_years,ds$study_name);t[t=="0"]<-".";t

       alsa lbsl satsa share tilda
  0    .    .    .     6     .    
  1    .    .    .     11    .    
  2    .    .    .     19    .    
  3    .    .    .     7     .    
  4    .    .    .     10    .    
  5    .    .    .     41    .    
  6    .    .    .     9     .    
  7    .    .    .     8     .    
.........................
  67   .    .    .     1     .    
  70   .    .    .     1     .    
  9999 .    .    .     10    .