DATA Step, Macro, Functions and more

Tranpose dataset

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 113
Accepted Solution

Tranpose dataset

Hello,

I have a dataset which is a crossbat between age group (in row, 16 categories) and municipality (in line, 79 categories):

123416
1245285335340320290
2250255305300240320
3147015602020160012551570
4520535580475375365
511901125128010407701065
79139516952130215018701265

I would like to transpose it in a data set of 3 rows and 79*16 lines:

MunicipalityAge GroupPopulation
11245
12285
,,,,
179290
,,,,,,
79141687
79151543
79161265

I'm sure it's easy, but I just don't know how.


Accepted Solutions
Solution
‎07-23-2013 05:50 PM
Super User
Posts: 19,789

All Replies
Solution
‎07-23-2013 05:50 PM
Super User
Posts: 19,789

Re: Tranpose dataset

Posted in reply to Demographer
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 155 views
  • 0 likes
  • 2 in conversation