Popular Topics
Popular Topics
Tuesday, May 29, 2012
SAS Is Wrong! R and Oracle Are Right. MOD(11169568236203649, 30269)=11732
For function MOD(11169568236203649, 30269), SAS returns 11731 while both Oracle and R return 11732. I used the following two approaches to verify SAS Is Wrong. Oracle and R are right.
Approach 1. The following two Oracle Queries show that 11732 is the remainder
SQL> select ( 11169568236203649 -11732)/30269 vl from dual;
369010150193.000000
SQL> select ( 11169568236203649 -11731)/30269 vl from dual;
369010150193.000033
Approach 2. The following PL/SQL scripts.
At first, I wanted to run the following PL/SQL Script 1. It took too long and I had to kill the process. Instead, I ran Script 2 shown below and it returned 11732 at the end of the loop.
PL/SQL Script 1.
set serveroutput on;
declare
remainder number;
begin
remainder:=11169568236203649;
while (remainder >30269)
loop
remainder:=remainder-30269;
end loop;
dbms_output.put_line(remainder);
end;
/
PL/SQL Script 2.
set serveroutput on;
declare
remainder number;
begin
remainder:=11169568236203649;
while (remainder>302690000000)
loop
remainder:=remainder-302690000000; /* equivalent of 10,000,000 loops of -30269 */
end loop;
dbms_output.put_line(remainder);
while (remainder>30269)
loop
remainder:=remainder-30269;
end loop;
dbms_output.put_line(remainder);
end;
/
At the end of the loop, it returns 11732.
Subscribe to:
Post Comments (Atom)
1 comment:
These can be classification, dimensional reduction, object recognition, clustering etc. It’s generally used on high dimensional data like text, images and sound. Through essay-services-review com there are other problems it has been used to solve.
Post a Comment