Proc import CSV with Comma in data

Reply
Occasional Contributor
Posts: 13

Proc import CSV with Comma in data

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

 

Super User
Posts: 23,683

Re: Proc import CSV with Comma in data

Posted in reply to Melvin_Sas

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. 

 

 

Ask a Question
Discussion stats
  • 1 reply
  • 193 views
  • 0 likes
  • 2 in conversation