I have two files, each with 3 variables.
The first one has date, city, and score. The second one has date, city and ret. Each has 49 cities.
I want to split each files to 49 stata files, by city.
Then merge the 49 score files with the 49 ret files by city and date.
Then merge each of the 49 files with a fulldate file (only one variable date with all the 365/366 dates per year).
merge 1:1 date using fulldate
Then for the 49 files, each
replace city="cityname" if missing(city)
Then append all the 49 files to one file.
Anyone can help?
Great thanks!
Related Posts with Split to multiple files, merge and append
LR testHi everyone, I've run a logit regression on my panel data. The sigma and LR test results are: Wald c…
Why im I getting a positive result with log-linear regression and a negative with linear-linear?Hi! I'm working on a project where I want to see the effect off an aviation tax on total passangers…
showing different confidence levels for IRF & positive versus negative shocks (VAR analysis)Hi all I have two basic questions for a VAR analysis: 1- I am estimating a var and plotting the orth…
Panel graph flightdataI'm using flightdata from origin to destination per year and quarter. I want to make a graph giving …
Data query with odbc: from R to StataHi all! I just got access to a SQL Server, where there is a database storing a number of metrics, t…
Subscribe to:
Post Comments (Atom)
0 Response to Split to multiple files, merge and append
Post a Comment