@YangYY
I tried again it still doesn't work.
Can you please try to copy my code and use the data "combined" to try your code again and see if it work?
data world_attr;
set mapsgfk.world_attr;
run;
proc sort data=world_attr;
by IDNAME;
run;
data world_attr;
set world_attr;
rename IDNAME=country;
run;
data combined;
merge world_attr co2_emission;
by country;
run;
I looked at the data for 176 countries in the Excel sheet giving CO2 Emissions. I don't see world_attr data set. You have not told the location for that.
Further, Excel sheet, I do not see "American Samoa" as you have given in your first post.
I insist that you closely examine your input data and DO the homework before asking further questions. Show your log for all your steps. If it is voluminous use sample of 20 rows. I am not your programmer to do all.
Good luck for finding the solution.
your work.
... View more
