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.

Assigning value from one variable to another if condition is met
Assigning value from one variable to another if condition is met

I have a data manipulation question:
I have a dataset with the variables "id_1", "year", and "id_2." I would like to create a new variable "year_new" that takes the value of the variable "year" in row 1, if "id_2" has the same value as id_1 in row 1. Essentially, "year_new[_n]" (in row _n) is assigned the value of "year[_n-x]" if "id_2[_n]" = "id_1[_n-x]", where x is some number.

Code:

id_1 year id_2 year_new
909 2019   2  .
  .    . 909   2019

Thank you for your help!

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Assigning value from one variable to another if condition is met
Assigning value from one variable to another if condition is met

0 Response to Assigning value from one variable to another if condition is met

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Assigning value from one variable to another if condition is met Assigning value from one variable to another if condition is met

0 Response to Assigning value from one variable to another if condition is met