Hi I am receiving error: ERROR: At least one of the columns in this DBMS table has a datatype that is not supported by this engine
I am connecting to teradata here is the query below. None of the attributes are bigint or anything they are char and int types. I have cast the count(*) and I still receive the error
select * from connection to eabc(
select hist_ky_add
,cast(count(*)as int) as countuniq
from (select cast(cust_id as decimal(15,0)) as cust_id_test
,cust_id
,cust_id_type
,cell_ky
,rank(cust_id || cust_id_type || cast(cell_ky as varchar(16))asc)as hist_ky_add
from &crnttblname) a
group by 1
having count(*) > 1
);
Can you see what is wrong? Any suggestions?
2 comments:
1. You can cast the other variables in turn to see which one causes the message. Or remove them from the query to perform the same test.
2. I am unsure SAS can read decimal variables. Why not an integer instead?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.