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.
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.
ReplyDelete