Hello!
I know there is the length limit for char variable (1024 positions); but if I have to import a field of a data base Oracle which contains a text (NVARCHAR), is there a tricks to do it? I use proc sql or data step.
Thanks a lot!
According to the Oracle documentation NVARCHAR won't exceed 32767 bytes and though can fit into a single SAS character variable.
Follow @SASKiwi's recommendation and set DBMAX_TEXT to 32767. That should resolve the issue.
Looks like you have run into the SAS option DBMAX_TEXT default setting of 1024. You can increase this to 32767 but no more than that as that is the size limit of SAS character variables.
How are you connecting to Oracle? The DBMAX_TEXT option can be used in database CONNECTION and LIBNAME statements.
According to the Oracle documentation NVARCHAR won't exceed 32767 bytes and though can fit into a single SAS character variable.
Follow @SASKiwi's recommendation and set DBMAX_TEXT to 32767. That should resolve the issue.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.