02-27-2018 01:28 PM
I am using the below code to import a CSV file into SAS data set from a Website. The value for a character variable contains Comma,Single Quotes and Double Quotes in it.
Eaxample : Luwin said, “Bran, the children's of the forest have been gone for thousands of years.”
When I Imported this into SaS , instead of assigning the value to one variable it creates mlutiple..
filename dat_input url 'https://XXXXXXXX.csv';
proc import datafile=dat_input
out=Check_XX dbms=CSV replace;
02-27-2018 01:39 PM
That indicates that you do not have a well formed CSV file.
You first need to figure out how many issues and what type of clean up you need to do.
I would also try setting GUESSINGROWS=MAX and see if you get a slightly better results.
If the variable happens to be at the end there are some workarounds you can try, but if it's in the middle its much harder.