topic Re: Import wrapped text from Excel in SAS Programming

Import wrapped text from Excel

HFatTRI — Mon, 23 Dec 2019 17:34:10 GMT

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?

Re: Import wrapped text from Excel

ballardw — Mon, 23 Dec 2019 17:36:58 GMT

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.

Re: Import wrapped text from Excel

HFatTRI — Tue, 24 Dec 2019 09:10:48 GMT

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;

Re: Import wrapped text from Excel

HFatTRI — Tue, 24 Dec 2019 10:20:12 GMT

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.