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
Compare elements of locals and return distingushing elementsDear all, I have the following three locals: Code: local house "1 2 3 4" local garden "1 2 3" loc…
XTQREG: how to add statistics to regression (e.g. pseudo R2) and how to determine the quantile?Hi, how do I include these extra statistics in xtqreg: - I want to add a measure of fit (such as the…
Question about graph bar command and how to include a second y-axis for a second variableDear Stata forum, I have a question about the graph bar command. So far, I have been using the foll…
Create a dataset from the current datasetHello Can someone help me create a dataset from my current dataset? I have the following dataset: …
How to find out if a string contains a specific string in it?Hey, what should I use in a conditional statement in order to execute a command only on observation…
Subscribe to:
Post Comments (Atom)
0 Response to Dropped Observations after Importing Excel Sheet as a CSV File
Post a Comment