Try this. the SQL step take all obs in the first data set and joins them to all matches in the 2nd data set. I also got rid of dsd and used dlm=',' instead. DATA FCRALL; infile datalines dlm=','; input id defect1; datalines; 111,1 222,1 333,2 444,0 ; run; DATA DEFECTS; infile datalines dlm=','; input defect1 description $20.; datalines; 1,Dead on Arrival 2,Welfare cull 3,Extra Bird Cull 4,Direct to Growout ; run; proc sql; create table join1 as select f.id, f.defect1, d.description from FCRALL as f left join DEFECTS as d on f.defect1=d.defect1; quit;
... View more
