Hi, I have come across a different set of coding as we can pass both numeric and character values at a time to a variable that was declared as numeric in Oracle warehouse. Example :- proc sql;
connect to oracle (XXXXXXXXXXXXXX user=&uid. password=&pwd. preserve_comments );
create table temp as
select * from connection to oracle
(select Var from CC
where var in ('023',23);
);
quit; It is working but could someone help me to understand how the SAS is not throwing an error when there are two format values given in a condition? If system is considering '023' as numeric and not a character even with quote this should work in local sas code too. but this is working only when we are hitting oracle data warehouse. data cc;
input var;
cards;
23
91
65
;
run;
proc sql;
create table temp as
select * from cc
where var in ('023',23);
quit Thanks
... View more