Data Consolidate and Transpose

[Lijuu]

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

[Kurt_Bremser · Accepted solution]

PROC REPORT does this in a single step:

proc report data=have;
column code population,year;
define code / group;
define population / analysis sum;
define year / "" across;
run;

[Lijuu]

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