Proc import CSV with Comma in data

[Melvin_Sas]

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;
getnames=yes;
GUESSINGROWS=10000;
run;

Thanks

[Reeza]

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.