I have an excel sheet I downloaded as a csv file. The number of observations is over 150,000. I imported the csv file, and noticed some things were off. After checking the number of observations with the original file, the number of observations in the imported file was at around 141,000. I was wondering if anyone knows why a fair amount of observations were dropped after importing the file. (I find this so strange. Also, as a small FYI, I am running on Stata 14).
This does not happen when I import the data as an excel file (.xlsx). However, when I import the excel file as a .xlsx, it runs slower and my variables turn into string variables. I have tried to destring them with destring, replace but it does not destring and reads the variables as non-numeric. I am a little bit at a loss. Thanks for any help and/or leads!
Related Posts with Dropped Observations after Importing Excel Sheet as a CSV File
Change label, color, and font for "by(category)" graphDear Statalist user, I use a very similar visualization to this: Code: use https://www.stata-pres…
reghdfe produce coefficients with opposite signI have problem with re-producing results using the same data using reghdfe command. The version of …
Regressions by industry - quarterDear users, I hope that you may help me with the following issue. I'm running regressions by indust…
Hypothesis testing between regression coefficientsHi everyone! So I created this regression table using the following commands Code: areg logincome l…
Stata coding (DID, Event study and Triple differences)Hello! I am doing DID, Event study and Triple differences, but it is not easy for me to make the ri…
Subscribe to:
Post Comments (Atom)
0 Response to Dropped Observations after Importing Excel Sheet as a CSV File
Post a Comment