quantiles with 2 variables
First, I will give a small introduction what I am planning to do.
I have data for approximately 6 years of retail investors. I want to check there performance for e.g. 3 years and then check how this influence their trading behavior (especially volume/turnover) and performance in the next 3 years.
I have the data for every month in separate excel files. So, what I did is: for every month I created a new excel file with the variables I want. I imported this into stata (OBDC data source --> excel files) and created a .dta file. After that I started to create a do-file, and this is where I have some trouble to decide what is the best option for me.
Short example:
I want to merge the datasets together. However, at the moment not all my variable names are not the same (e.g. net_performance_jan_00, net_performance_febr_00, etc). So, the append command doesn't work properly then. Now my question is: is it better to use "append" and put the data together in these (eight) variables, or is it better to use "merge" and add new variables every month?
The reason why I am asking this question is that I have a variable called account_ID, which are numbers. Most numbers will come back every month, and I am wondering if this can create any problems if I use append to merge the different .dta together.
Thank you for your time and I hope that my question is clear
First, I will give a small introduction what I am planning to do.
I have data for approximately 6 years of retail investors. I want to check there performance for e.g. 3 years and then check how this influence their trading behavior (especially volume/turnover) and performance in the next 3 years.
I have the data for every month in separate excel files. So, what I did is: for every month I created a new excel file with the variables I want. I imported this into stata (OBDC data source --> excel files) and created a .dta file. After that I started to create a do-file, and this is where I have some trouble to decide what is the best option for me.
Short example:
Code:
use jan00.dta, clear
append using febr00.dta
save master.dta, replace
append using march00.dta
save master.dta, replace
etc
The reason why I am asking this question is that I have a variable called account_ID, which are numbers. Most numbers will come back every month, and I am wondering if this can create any problems if I use append to merge the different .dta together.
Thank you for your time and I hope that my question is clear
Last edited: