excel for mac escape single quotes in csv

'id,EntryDate,FirstName,LastName,Status1,Status2,Location,OtherAddress' Let's make your example file with one line that has a couple of embedded line breaks. If _ERROR_ then call symputx('_EFIERR_',1) /* set ERROR detection macro variable */ Infile 'weirdformat.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 %let _EFIERR_ = 0 /* set the ERROR detection macro variable */ Id,EntryDate,FirstName,LastName,Status1,Status2,Location,OtherAddress'8','','First Name 1','Last Name 1','Below Status1 Level','','ABC D clinic','' Is there a better way to import and/or to clean up these line breaks/spaces?

I've tried adding TERMSTR=CRLF but it doesn't help and causes even worse formatting. Aside from deleting these problem columns, I can't figure out a good way to import these files completely. There are empty columns, and often, fields with long string such as addresses, business names, etc will have a line break interspersed throughout the files. I have very large CSV files with 100+ variables that look something like this:

Excel for mac escape single quotes in csv