I read some data from a Netezza database, with this nice data, e.g.: F2F0F2F060F0F860F0F360F0F34BF1F24BF2F94BF9F4F6F7F4F1F3F8F3F7F8F9404040 It is a timestamp (YYYY-MM-DD-HH.MM.SS.999999999999). But SAS can´t read hex-vars longer than 16 chars, as numbers. If I input the above, with $hex70. it returns nonsense. Netezza keeps timestamps like this: Min: -63,082,281,600,000,000 (00:00:00, 1/1/0001) Max: 252,455,615,999,999,999 (23:59:59.999999, 12/31/9999) Any suggestions?
... View more