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.

Sum of a variable over all observations except one (loop)
Sum of a variable over all observations except one (loop)

Dear all,

Let's suppose I have a variable displaying the amount of input in a given industry for each country: X_AUSTRALIA, ..., X_JAPAN, ..., X_USA, etc.

My goal is to create a new variable for each country which would be the sum of X excluding the country I am interested in. For instance, for Australia, I want the sum of X over all countries except Australia, and so on for each country.

Ideally, I would like to do that in a loop since I have a lot of countries. I have already created a global containing all the countries.

Anyone has an idea about how to produce theses variables within a loop ? That would be very appreciated. Thank you.

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Sum of a variable over all observations except one (loop)
Sum of a variable over all observations except one (loop)

0 Response to Sum of a variable over all observations except one (loop)

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Sum of a variable over all observations except one (loop) Sum of a variable over all observations except one (loop)

Related Posts with Sum of a variable over all observations except one (loop)

0 Response to Sum of a variable over all observations except one (loop)