Hi, We are connecting to SingleStore using Access to ODBC and noticed that SAS Enterprise Guide (v7.13) (SAS 9.4 9.04.01M7P080620) shows SingleStores binary(32) datatype as a column with: Type: character Length 32 Format $HEX64. Informat $HEX64. If we browse the table in SAS EG the content of this binary column (hub_burger_hkey) is shown as '2A2A2A2A...' for all records even if the underlying value is different. Grouping on this column gives correct results but all values are shown as '2A2A2A2A2A...' .. which is of course not easy to work with when identifying records. When trying to store it with a $32. format it is possible to show it correctly... but we don't find any other way to do so. Is there anyone who has any idea how we can let SAS EG visualise this type of binary column correctly without rewriting the data into SAS datasets (using just a hex format doesn't work neither)? PROC SQL;
CREATE TABLE WORK.TEST AS
SELECT t1.hub_burger_hkey AS hub_burger_hkey_hex64,
/* HKEY_ALS_CHAR32 */
(put(t1.hub_burger_hkey,$32.)) AS HKEY_ALS_CHAR32,
t1.hub_burger_hkey FORMAT=$hex32. AS hub_burger_hkey_format_hex32,
t1.hub_burger_hkey FORMAT=$32. AS hub_burger_hkey_format_char32
FROM _BINTEST.hub_burger_binary t1
WHERE t1.burger_bk = '60027907';
QUIT; Thanks in advance, Danny
... View more
