Hello, I’m trying to start my first legit data project using Stata but am stumbling out of the gate. I’m trying to import data from the public lobbying database (https://www.senate.gov/legislative/P...e_download.htm), which has been saved in compressed XML format. I’m using Stata SE version 11.2 and when I attempt to import the data as XML data I get the following error:
xmluse "D:\data\SOPR\2014_1_1_1.xml"
unrecognizable XML doctype
r(198);
When going back to excel and saving the data as an XML Spreadsheet 2003 file and then attempting to open in Stata I get:
data type of Excel column not consistent
specifying the missing option will import inconsistent values as missing data
while the allstring option will import all as strings
file not Stata format
r(610);
Using those suggested options seems to import the data, insofar as the variables window shows the correct number of variables, however when I browse the data editor I find that nearly every cell is empty…
I’ve tried saving the data in a couple other formats, but Stata either tells me it’s unrecognizable or, in the case of attempting to import it as CSV comma delimited data (as per 3.2: http://www.stata.com/support/faqs/da...g-excel-files/), the command “import” isn’t recognized.
Anyone know how I can get this lobbying data into Stata? I would be mucho grateful!
xmluse "D:\data\SOPR\2014_1_1_1.xml"
unrecognizable XML doctype
r(198);
When going back to excel and saving the data as an XML Spreadsheet 2003 file and then attempting to open in Stata I get:
data type of Excel column not consistent
specifying the missing option will import inconsistent values as missing data
while the allstring option will import all as strings
file not Stata format
r(610);
Using those suggested options seems to import the data, insofar as the variables window shows the correct number of variables, however when I browse the data editor I find that nearly every cell is empty…
I’ve tried saving the data in a couple other formats, but Stata either tells me it’s unrecognizable or, in the case of attempting to import it as CSV comma delimited data (as per 3.2: http://www.stata.com/support/faqs/da...g-excel-files/), the command “import” isn’t recognized.
Anyone know how I can get this lobbying data into Stata? I would be mucho grateful!
