BookmarkSubscribeRSS Feed
Petersi
Calcite | Level 5
Does anyone use ODBC? I am reading an Access database with PROC SQL on an ODBC connection. My problem is that SAS is treating all character columns as $255. Is there a way to re-format these columns within the SQL?
2 REPLIES 2
Cynthia_sas
SAS Super FREQ
Hi:
This Tech Support note is fixing a slightly different length issue with ODBC, but the technique may work for your MS-Access table.
http://support.sas.com/techsup/unotes/SN/017/017463.html

Otherwise, your best bet may be to contact Tech Support for more specific help on this issue.

cynthia
DouglasMartin
Calcite | Level 5
I think you just want the DBMAX_TEXT=n option on your libname statment or dataset option. Check out the documentation on it. The value you set becomes the maximum width that will be read. The maximum is 32767. HOWEVER, one thing I did notice is that my programs did get slower the higher I set it, so be careful about going overboard with it. (I don't have any examples because I switched jobs recently and no longer have a need for it). Message was edited by: Douglas Martin

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
  • 751 views
  • 0 likes
  • 3 in conversation