topic Re: Avoiding truncations when importing from Excel in Microsoft Integration with SAS

Avoiding truncations when importing from Excel

deleted_user — Mon, 01 Oct 2007 12:33:38 GMT

Hi,

When importing an Excel spreadsheet using PROC IMPORT, text fields which are longer than 255 characters are truncated. How can I avoid this? I have searched the web and tried setting different options but didn't succeed in finding a solution so far. I hope that someone in this forum can help me.

Thanks,

Helle

Re: Avoiding truncations when importing from Excel

Cynthia_sas — Mon, 01 Oct 2007 14:41:43 GMT

Hi:
This Tech Support Note http://support.sas.com/techsup/unotes/SN/019/019409.html
seems exactly relevant to your situation. To find this Note, I went to:
http://support.sas.com/techsup and in the search box on the right hand side of the first Tech Support screen, I typed
[pre]
IMPORT Excel truncate 255
[/pre]
into the search box. This Note was the 4th item returned.

cynthia

Re: Avoiding truncations when importing from Excel

deleted_user — Tue, 02 Oct 2007 06:32:47 GMT

Hi Cynthia,

Thanks a lot for your help - this was exactly what I needed 🙂

Helle