SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Avoiding truncations when importing from Excel

Reply
N/A
Posts: 0

Avoiding truncations when importing from Excel

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
SAS Super FREQ
Posts: 8,716

Re: Avoiding truncations when importing from Excel

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
N/A
Posts: 0

Re: Avoiding truncations when importing from Excel

Hi Cynthia,

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

Helle
Ask a Question
Discussion stats
  • 2 replies
  • 207 views
  • 0 likes
  • 2 in conversation