topic match two tables with a common var in SAS Programming https://communities.sas.com/t5/SAS-Programming/match-two-tables-with-a-common-var/m-p/152597#M30040 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.800000190734863px; background-color: #ffffff;">In the attached two files , there is a common variable NAICS. I need to add I-o code from <SPAN style="color: #222222; font-family: arial, sans-serif; font-size: 12.800000190734863px; background-color: #ffffff;">file NAICS-IO.txt </SPAN> to file "NAICS97.txt". Note: file NAICS-IO.txt has a column NAICS, but the values expands to several columns in some cases. </P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.800000190734863px; background-color: #ffffff;"></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.800000190734863px; background-color: #ffffff;">is there a easy way to do this match in SAS?</P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.800000190734863px; background-color: #ffffff;"></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.800000190734863px; background-color: #ffffff;">thanks so much,</P></BODY></HTML> Fri, 22 Nov 2013 03:11:07 GMT LanMin 2013-11-22T03:11:07Z match two tables with a common var https://communities.sas.com/t5/SAS-Programming/match-two-tables-with-a-common-var/m-p/152597#M30040 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.800000190734863px; background-color: #ffffff;">In the attached two files , there is a common variable NAICS. I need to add I-o code from <SPAN style="color: #222222; font-family: arial, sans-serif; font-size: 12.800000190734863px; background-color: #ffffff;">file NAICS-IO.txt </SPAN> to file "NAICS97.txt". Note: file NAICS-IO.txt has a column NAICS, but the values expands to several columns in some cases. </P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.800000190734863px; background-color: #ffffff;"></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.800000190734863px; background-color: #ffffff;">is there a easy way to do this match in SAS?</P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.800000190734863px; background-color: #ffffff;"></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.800000190734863px; background-color: #ffffff;">thanks so much,</P></BODY></HTML> Fri, 22 Nov 2013 03:11:07 GMT https://communities.sas.com/t5/SAS-Programming/match-two-tables-with-a-common-var/m-p/152597#M30040 LanMin 2013-11-22T03:11:07Z