BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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
2 REPLIES 2
Cynthia_sas
Diamond | Level 26
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
deleted_user
Not applicable
Hi Cynthia,

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

Helle

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Discussion stats
  • 2 replies
  • 1485 views
  • 0 likes
  • 2 in conversation