Formulas with and without Parentheses
The formula with parentheses needs two pairs of single quotation marks. The formula without parentheses needs only one pair of single quotation marks.
call td_analyze ( 'vartran', 'database = val_source; tablename = customer; derive = {formula (x+y+z), arguments (income, age, years_with_bank), outputname (myoutput)} {formula (''x(x+1)''), arguments (age), outputname (myoutput2)};' );
Null Replacement
keycolumns is required.
call td_analyze ( 'vartran', 'database = val_source; tablename = customer; keycolumns = cust_id; derive = formula (''x(x+1)''), arguments (age), outputname (myoutput), nullstyle (literal, 0);' );