Hello,
I'm trying to import excel data into stata and it seems to misplace some values. Most values are in the matched cell as in the excel spreadsheet but some values are in the wrong column or row. Let's say I have a "industry" variable and one of its value is like "Wholesale/Trade - footwear, clothes, accessories." Although these whole phrases should be in one cell, they are somehow separated and appear in the two different cells and not even in the continuous cells. e.g. "clothes, accessories" in the totally random cell far below. Do you know why this happens and how to correct them? I hope that I don't do this manually...
Thank you for your help in advance!
Related Posts with when importing excel into stata
Lagging a variable 1 or more years from data on daily stock prices to use in OLS regressionI am trying to make an empirical study on the effect of dividend changes on future firm performance.…
Loop code for Wide DataHi All, I'm struggling with the code for loops using wide data. I include a sample of the data and …
Predictor variables became not significant in fixed effect model.Hi. I am using Stata 15.1 and here is sample of my data. My main predictor variables are winpowersh …
In panel dataset where ID= household; method to understand if the same ID lived in the same housing unit over the entire time period?Hello everyone, sorry for the confusing title, I didn't manage to find a short and comprehensible w…
Clubbing categories within variablesDear all, This is my data. Code: * Example generated by -dataex-. To install: ssc install dataex…
Subscribe to:
Post Comments (Atom)
0 Response to when importing excel into stata
Post a Comment