*********************************************************************** * Program: C:\NHANES\AppendMerge_MergeData.sas * * Proposal: Merge NHANES Data * ***********************************************************************; libname nh "C:\NHANES\data\your_dir"; options ls=72; proc sort data=nh.DEMO_4yr; by SEQN; proc sort data=nh.BPX_4yr; by SEQN; proc sort data=nh.BPQ_4yr; by SEQN; proc sort data=nh.MCQ_4yr; by SEQN; proc sort data=nh.LAB13_4yr; by SEQN; run; data DEMO_BP (drop=dmdeduc) ; merge nh.DEMO_4yr nh.BPX_4yr nh.BPQ_4yr nh.MCQ_4yr nh.LAB13_4yr; by SEQN; run; proc contents data=DEMO_BP varnum; proc means data=DEMO_BP N Nmiss min max maxdec=2; run;