Import wrapped text from Excel

[HFatTRI]

When trying to import an Excel sheet with a column containing wrapped text, only the first line of text gets imported. 

Can I import all the text in the column with wrapped text without "unwrapping" it manually?

[ballardw]

Pleas shoe the code for how you are "importing" the file.

Ideally provide an example of the file but I realize that may not be possible.

"Wrapping" should not be any issue. More like is the presence of line breaks cause by using Alt-Enter but without an example it may be difficult to provide an specific solutions.

[HFatTRI]

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;

[HFatTRI · Accepted solution]

It turns out the problem was not the proc import but a subsequent combination of datasets in a data step.

So I learned from this that wrapped text does not appear to be a problem and that you may have to use a length statement when combining multiple datasets to avoid truncation, even though the variables in each dataset have the same lengths in bytes.