(I'm using version 15.1)
I am reading in a series of similarly formatted Excel files. (These are precinct election returns for New Mexico, in which each file contains the results for a separate office --- governor, senator, etc.) I was successful in reading in one of the Excel files by issuing the simple command:
import excel using "new mexico governor.xlsx", clear
(By "successful" I mean that all rows of the first worksheet in the file were pulled in --- 41 --- and that all columns were pulled in (A, B, and C). All the data elements from the spreadsheet were included in the import.)
However, when I went to read in the next file by issuing the command:
import excel using "new mexico attorney gen.xlsx", clear
I ended up with a Stata dataset that had the correct structure (41 rows and columns A, B, and C), but all the data were missing.
The same thing happened with the other spreadsheets I tried this on.
I have tried: (1) using all the options to the import excel command and (2) re-downloading the spreadsheets.
Any thoughts?
Related Posts with import excel imports sheet structure, but no data
Inverse Probability Weighing for Multiple TreatmentsHi all, I am trying to compute inverse probability weight for multiple treatments. But I am struggl…
Multiple imputation convergence not achievedHi all, I'm trying to perform chained multiple imputations but get an error message about convergen…
How to run the Stata code for specific number of observations in panel data?Because when running the code below, it seems that Stata takes a long time to run it, so I want to t…
What is the c.operator in reg and set emptycells ?Today when I run this regression Code: did2s l_homicide [aweight=popwt], first_stage(i.sid i.year)…
mediation effect and endogenousDear sir or madam: But I have some question about the mediation effect and endogenous: Is there a tr…
Subscribe to:
Post Comments (Atom)
0 Response to import excel imports sheet structure, but no data
Post a Comment