Prev: C or Java code in Extension Nodes
Next: SAS 8 & 9: Numbers getting turned into Notation
From: steve on 14 Feb 2010 18:05
Hi;

I have a number of SAS tables that retrieved from MS SQLServer and
translated into *sas7bdat files via a DBMSCopy script ( yes, I know
there are better tools ). In these tables we have a unique ID for
each record. These IDs are integers.

I noticed once these IDs start becoming large numbers they can no
longer be viewed in my SAS Viewer as numbers, but seem to be turned
into some kind of notation.

For example 145563 might get turned into something like 15E4
(roughly).

I noticed a similar issue pasting columns of large integers into
Microsoft Excel. The problem went away when I set the number format
in Excel to be "text".

I'm wondering if that could the issue with SAS Viewer. These tables
are generated/translated by DBMSCopy and some SAS scripts ( which I
don't have direct access too ).

Can this problem be prevented by first converting my IDs to a string
data type before translating them into SAS ?

Thanks much in advance

Steve
 | 
Pages: 1
Prev: C or Java code in Extension Nodes
Next: SAS 8 & 9: Numbers getting turned into Notation