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.

Divide data into groups according to percentile rank AND another given variable (if tie exists)
Divide data into groups according to percentile rank AND another given variable (if tie exists)

Hi experts!

I have a four-year repeated cross-sectional data set. I want to divide my observations (within each year) into 400 equal-sized groups according to their income ranks. In addition, whenever there are ties, I want to assign ranks according to the value of another given variable.

I only know that we can do the following:

xtile newvar = income, n(400)

But xtile does not seem to allow me to introduce an additional variable to assign ranks when there are ties. Is there any simple method or user-written command? Thank you!

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Divide data into groups according to percentile rank AND another given variable (if tie exists)
Divide data into groups according to percentile rank AND another given variable (if tie exists)

0 Response to Divide data into groups according to percentile rank AND another given variable (if tie exists)

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Divide data into groups according to percentile rank AND another given variable (if tie exists) Divide data into groups according to percentile rank AND another given variable (if tie exists)

0 Response to Divide data into groups according to percentile rank AND another given variable (if tie exists)