topic Re: Data Consolidate and Transpose in SAS Programming

Data Consolidate and Transpose

Lijuu — Mon, 03 Apr 2023 05:27:50 GMT

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 — Mon, 03 Apr 2023 07:19:08 GMT

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 — Tue, 04 Apr 2023 01:34:17 GMT

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