Prev: Two Hyperlinks on Same Line
Next: %Include Question
From: Scott Barry on 14 Sep 2009 16:58
On Mon, 14 Sep 2009 16:49:00 -0400, Evan Davies <esdav2(a)WM.EDU> wrote:

>My Sungard/Banner RDBMS recently converted every character variable to
>accept the international character set. I use SAS connect to ODBC to PROC
>SQL select data from the Banner system to archive into discrete permanent
>SAS data sets. The internationalization apparently has inflated the length
>of every character variable by a factor of 4, and the storage space required
>has become a problem.
>
>I can issue a length, format and informat statement for each and every
>variable selected to chop things back down to size, but am searching for a
>less labor-intensive way of specifying that I don't need the international
>characters in text variables like Academic_term and Enrollment_status, and
>in fact, don't really even need it in Name variables.
>
>Has anyone had any experiences with this problem and found any system
>settings or controls in either PROC SQL or Sas/Connect to ODBC that will
>prevent the quadrupling of variable storage size? The variables are stored
>as VARCHAR2 on the ORACLE side, if that helps. Is there any SAS equivalency
>to VARCHAR2 that would function to not import the maximum variable length
>for a variable, but just the existing characters?

This document has an Oracle section:

SAS 9.1.3 Service Pack 4 in a Unicode Environment
http://support.sas.com/resources/papers/unicode913.pdf

Scott Barry
SBBWorks, Inc.
 | 
Pages: 1
Prev: Two Hyperlinks on Same Line
Next: %Include Question