/*ohqAB.sas*/
/*Date created 3/12/2005*/
/*Combine NHANES Oral Health Questionnaire Datasets for 1999-2000 and 2001-2002*/
/*Variable SDDSRVYR=1 for 1999-2000 and SDDSRVYR=2 for 2001-2002*/

LIBNAME NHANESA "K:/DOH/EVERYONE/NHANES/NHANES19992000/OriginalFiles/data_SASV8";
LIBNAME NHANESB "K:/DOH/EVERYONE/NHANES/NHANES20012002/OriginalFiles/data_SASV8";
LIBNAME NHANESAB "K:/DOH/EVERYONE/NHANES/NHANES19992002/AnalysisFiles";

/*Rename variables in ohq 1999-2000 to same name as in ohq_b 2001-2002*/
data NHANESA.ohq_a;
set NHANESA.ohq;
rename
  OHQ080=OHQ085
  OHQ090=OHQ095
  OHQ100=OHQ105
  OHQ110=OHQ115
;
run;

/*sort data sets for merge*/
proc sort data=NHANESA.ohq_a; /*Oral Health Questionnaire 1999-2000 with variable names changed*/
 by SEQN;
proc sort data=NHANESB.ohq_b; /*Oral Health Questionnaire 2001-2002*/
 by SEQN;
run;

/*Combine 1999-2000 and 2001-2002 Oral Health Questionnaire datasets*/
data NHANESAB.ohqAB;
set NHANESA.ohq_a NHANESB.ohq_b;
run;

/*end ohqAB.sas*/