I want to import the file "corona-cases.csv" from http://www.dkriesel.com/_media/corona-cases.csv
With the process block "Test File Importer" I get an error
(ERROR: Variable label "Cote dIvoire;LABEL Croatia=Croatia;LABEL Cuba=Cuba;LABEL...)
The problem - I think- is the single quote in the coloumn name "Cote d'Ivoire".
Any idea how to deal with this?
My solution at this time is to wrote sas code load the file with proc http and change the apostrph in "Cote d'Ivoire". Then the process block "Test File Impoter" works.
Please sign in to leave a comment.