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
SAS Super FREQ
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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