SAS CODE FOR MERGING CFF DATA WITH CODEBOOK LOOK-UP TABLE                       
                                                                                
*****--------------------------------------------*****;                         
*    1.0 Set library names.                                    *;               
                                                                                
                                                                                
*****--------------------------------------------*****;                         
                                                                                
libname in1 'CFF';                                                              
libname in2 'CODEBOOK';                                                         
                                                                                
*****--------------------------------------------*****;                         
*    2.0 Add USDA Food Descriptions.                 *;                         
*****--------------------------------------------*****;                         
PROC SORT  DATA=IN1.CFF OUT=CFFDATA;                                            
           BY DRPCCODE;                                                         
                                                                                
PROC SORT  DATA=IN2.CODEBOOK OUT=CODEBOOK;                                      
           BY DRPFCODE;                                                         
                                                                                
DATA CFFDATA;                                                                   
           MERGE   CFFDATA(in=a )                                               
                   CODEBOOK                                                     
                       (in=b rename=(drpfcode=DRPCCODE));                       
           BY DRPCCODE; IF A;                                                   
                                                                                
     if drptcc=2   then drpfd='Frozen Meal Combination';                        
     if drptcc=3   then drpfd='Salad Combination';                              
     if drptcc=7   then drpfd='Beverage Combination';                           
     if drptcc=9   then drpfd='Bread with Additions Combination';               
     if drptcc=10  then drpfd='Cereal Combination';                             
     if drptcc=12  then drpfd='Vegetables with Additions Combination';          
     if drptcc=13  then drpfd='Vegetables Combination';                         
     if drptcc=14  then drpfd='Dessert Combination';                            
                                                                                
RUN;