Thank you very much. Really Apreciated, it is working well. ... View more

Dears: I have data in the following format: Year    Code    Population  2000   1001     10 2000   1001     15 2001   1001     4 2002   1001     3 2002   1001     5 2000   1002     5 2000   1002     8 2001   1002     10 2002   1002     25 2002  1002      30   I want to have a total population per year and code it as Year  Code Population 2000   1001   25 2001   1001    4 2002   1001    8 2000   1002    13 2001   1002    10 2002   1002    55   And finally, I want to transpose the total population per year as Code  Population_2000  Population_2001  Population_2002 1001           25                        4                             8 1002           13                       10                           55 Thank you very much for your help. Lijalem   ... View more

It is never of any use to say "it is not working".   We need to know exactly what you did (show us the code) and what happened that indicates it is not working (show us the log or the output). ... View more

Why do you want to use the coordinates? Isn't the county name sufficient? ... View more

There's no %TEST macro in the link you provided either.   So please show us the code that calls %TEST, because that is where the error is happening. ... View more

Thank you Dear Rick! ... View more

indeed, i was thinking like what you said but it doesn't make sense for the owner of the data. ... View more

Ok! Thank you much in advance!!! ... View more