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.

count the number of distinct observations across variables
count the number of distinct observations across variables

Hello Stata folks, I am working on a dataset that each school ID has 7 years of data capturing principal's ID. I need to count the number of distinct principal ID each school has had over the past seven years. But the data is not unique on school ID nor principal ID. Can anyone tell me how I should deal with it? Thanks!

for instance, my data looks like below (i only kept two years of data here as an example)

Code:

school    principal_yr1    principal_yr2
1111    100888    117583
1111    100999    124853
1111    100888    283043
2222    113824    176392
3333    158345    483572
4444    189999    184257
4444    189999    184925

Thanks.

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / count the number of distinct observations across variables
count the number of distinct observations across variables

0 Response to count the number of distinct observations across variables

Post a Comment

Home / Data Cleaning / Data management / Data Processing / count the number of distinct observations across variables count the number of distinct observations across variables

0 Response to count the number of distinct observations across variables