/*ohxperAB.sas*/
/*Date created 3/12/2005*/
/*Combine NHANES Oral Health Periodontal Datasets for 1999-2000 and 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 ohxperio 1999-2000 to same name as in ohxpru_b and ohxprl_b 2001-2002*/
/*Variables that occur in both cycles use the same names*/

/*sort data sets for merge*/
proc sort data=NHANESA.ohxperio; /*Oral Health Periodontal 1999-2000*/
 by SEQN;
proc sort data=NHANESB.ohxpru_b; /*Oral Health Periodontal - Upper quadrants 2001-2002*/
 by SEQN;
proc sort data=NHANESB.ohxprl_b; /*Oral Health Periodontal - Lower quadrants 2001-2002*/
 by SEQN;
run;

/*Merge periodontal datasets for 2001-2002 upper and lower quadrants*/
data NHANESB.ohxper_b;
merge NHANESB.ohxpru_b NHANESB.ohxprl_b;
by SEQN;
run;

/*Combine 1999-2000 and 2001-2002 Oral Health Periodontal datasets*/
data NHANESAB.ohxperAB;
set NHANESA.ohxperio NHANESB.ohxper_b;
run;

/*end ohxperAB.sas*/