Hi, ballardw. Yes I think you're right, it's probably the line breaks that are the problem. Unfortunately I can't provide a file, the text in the column I'm trying to import looks like this: Option 1; Option 2; Option 3; I would like to import that as one long string but only the first line (Option 1; ) gets imported. Here is what the code looks like (preceded by a filename statement): proc import datafile=tmp dbms = xlsx replace out=study (keep=a--n drop=g h i j k ); sheet="eCRF" ; datarow=28; getnames=no; run;
... View more
