(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
Rolling estimates with confidence intervals (graph)Dear all, I found this question here. Please ssc install rangestat. The question is, after running r…
Failing to replicate margins example 16: Average marginal effect (partial effects)This is the code for margins Example 16 Code: use https://www.stata-press.com/data/r17/margex quie…
Discrepancy for Shapiro-Wilks value between Stata (v15) vs. SPSS 26 and JASP 15.Hello, This is an unusual question as it involves statistical platforms outside of Stata. I'm teach…
JackknifeHello everyone, I have a question about comparing linear regression model and jackknife method. I e…
Fixed effects in first-differenced modelHi! I have a first-differenced model, where my units are municipalities. I am adding regional fixed…
Subscribe to:
Post Comments (Atom)
0 Response to import excel imports sheet structure, but no data
Post a Comment