SHOW:
|
|
- or go back to the newest paste.
| 1 | - | 1. data mge; |
| 1 | + | 1. proc sql; |
| 2 | - | 2. merge prdsal2(in=prd) us_data(in=us |
| 2 | + | 2. create table state as |
| 3 | - | 3. rename=(statename=state)); |
| 3 | + | 3. select country, product, statename, population_2010 |
| 4 | - | 4. by state; |
| 4 | + | 4. from sashelp.prdsal2 as Product, sashelp.us_data as US; |
| 5 | - | 5. if prd=1 and us=1; |
| 5 | + | 5. where product.state = US.statename; |
| 6 | - | 6. keep COUNTRY PRODUCT STATE |
| 6 | + | 6. quit; |
| 7 | - | 7. POPULATION_2010; |
| 7 | + |
