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.

Creating a variable by finding correlations of two other variables
Creating a variable by finding correlations of two other variables

Hi everyone,

I am trying to create a variable [pre], the value of which will be the correlation of two other variables [price_return and equal_weighted_return].

I tried using egen, but it generated a lot of missing values even though both the variables had values applicable. My codes were the following:

sort fiscalyear

egen pred2=corr( price_return equalweightedreturnincldivi), by(fiscalyear)
(55442 missing values generated)

I am working with a panel dataset, however if i sort the data using two identifiers [company_id and fiscalyear], I am getting more missing values.

Any suggestions to solve this easy problem?

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Creating a variable by finding correlations of two other variables
Creating a variable by finding correlations of two other variables

0 Response to Creating a variable by finding correlations of two other variables

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Creating a variable by finding correlations of two other variables Creating a variable by finding correlations of two other variables

0 Response to Creating a variable by finding correlations of two other variables