BJ Data Tech Solution

Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.

Collapse with percentage of population in a dummy variable wrt region and year
Collapse with percentage of population in a dummy variable wrt region and year

Hi everyone,

I am currently working with data of following Format

Year Region Dummy
2001 11 0
2001 11 0
2001 11 1
2001 12 1
2001 12 1
2001 12 0
2002 11 1
2002 11 1
2002 11 1
2002 12 1
2002 12 0

I want to collapse the data in such a way that i have result like this

Year Region percentage of population in a region in a given year that has dummy value 1
2001 11 0.33
2001 12 0.66
2002 11 1
2002 12 0.66

Any help in this regard is highly appreciated.

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Collapse with percentage of population in a dummy variable wrt region and year
Collapse with percentage of population in a dummy variable wrt region and year

0 Response to Collapse with percentage of population in a dummy variable wrt region and year

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Collapse with percentage of population in a dummy variable wrt region and year Collapse with percentage of population in a dummy variable wrt region and year

0 Response to Collapse with percentage of population in a dummy variable wrt region and year