1.  proc sql;
2.  create table state as
3.  select country, product, statename, population_2010
4.  from sashelp.prdsal2 as Product, sashelp.us_data as US;
5.  where product.state = US.statename;
6.  quit;