Hi,

I have not been able to resolve an error with an import delimited syntax. The error is r(198) "could not name variables specified".

Code:
* i have tried lots of different variations.  here are the two simpliest
import delimited zip_code using "TTS_LBNL_public_file_19-Oct-2020_p1.csv", varnames(1) stringc(_all) clear
import delimited zip_code using "TTS_LBNL_public_file_19-Oct-2020_p1.csv", varnames(1) delim(",") stringc(_all) clear

* the full command I wanted to use and started with is this:

import delimited zip_code state system_size_DC customer_segment installation_date module_quantity_1    module_quantity_2 module_quantity_3 nameplate_capacity_module_1    nameplate_capacity_module_2    nameplate_capacity_module_3 using TTS_LBNL_public_file_19-Oct-2020_p2.csv, varnames(1) delim(",") stringc(_all) clear

* all the variations I have tried result in this error
I was not able to find a discussion of this error online. I suspect it is something very simple I am failing to see

FYI the file I am trying to import is downloadable here: https://emp.lbl.gov/tracking-the-sun

Any ideas?

Thanks in advance,

Ben


Ben Hoen
Research Scientist
Lawrence Berkeley National Laboratory