Abstract: System and method for translating statements and expressions within statistical language programs into SQL. These statements include one or more input statements and have a plurality of data rows. These statements include one or more array statements, the array statements having a set of original variables. The method for translating statements and expressions within statistical language programs into SQL includes the step of defining a select statement including a subset of the original variables. The expressions include one or more assignment expressions, the assignment expressions including a set of original variables and a set of new variables affected by the assignment expressions.

Abstract: System and method for translating statements and expressions within statistical language programs into SQL. These statements include one or more input statements and have a plurality of data rows. These statements include one or more array statements, the array statements having a set of original variables. The method for translating statements and expressions within statistical language programs into SQL includes the step of defining a select statement including a subset of the original variables. The expressions include one or more assignment expressions, the assignment expressions including a set of original variables and a set of new variables affected by the assignment expressions.

Abstract: A system and method of evaluating an SQL recursive query having one or more base select statements and one or more recursive select statements. In one technique the query relates to a base table and has a filter condition on one or more columns from a result table returned by the query. The technique includes the steps of receiving the query to be evaluated, evaluating a base step by evaluating one or more of the base select statements, evaluating one or more recursive steps by evaluating one or more of the recursive select statements, evaluating the filter condition prior to evaluating any of the recursive steps, and returning the result of the query.