I have changed your initial code. DATA FCRALL; infile datalines dsd; input id defect1; datalines; 111,1 222,1 333,2 444,0 ; DATA DEFECTS; infile datalines dsd; input defect1 description $20.; datalines; 1,Dead on Arrival 2,Welfare cull 3,Extra Bird Cull 4,Direct to Growout ; PROC SORT DATA=DEFECTS; BY DEFECT1; PROC SORT DATA=FCRALL; BY DEFECT1; /* This is what you can do and hope it is helpful */ data want; merge fcrall (in = a) defects (in = b); by defect1; /* If you want only the matching col */ if a and b; /* If you need to a left join as Gregg pointed out use if a; */ run;
... View more