proc sql; connect to oracle (user=userid password=xxxx path=mydatabase); create table work.sas_score_out1 as select * from connection to oracle (SELECT * from table(SASEPFUNC(CURSOR(select * from intrtree), 'myschema.SAS_PUBLISH_MODEL', 'INTRREG1', 'null', 'select * from intrtree')); disconnect from oracle;quit;
specifies the SELECT statement to read from the input table.
Tip | You can specify a hint for the degree of parallelism (dop) value that is used for reading the input table. For more information, see Run-Time Guidance for the Oracle Degree of Parallelism (DOP) Setting. |
specifies an alias for the input table name.
Requirement | The table alias must be the same in the parallel hint and the FROM clause. |
specifies the name of the input table that is used by the SASEPFUNC table function.
specifies the fully qualified model table name.
Requirement | The table name that you specify for this function must be the same table name that is used in the %INDOR_CREATE_MODELTABLE macro. For more information, see Creating a Model Table. |
specifies the model name.
Requirement | The model name must be the same name that is used in the %INDOR_PUBLISH_MODEL macro. For more information, see %INDOR_PUBLISH_MODEL Macro Syntax. |
specifies a placeholder value at this time
Tip | You can specify either 'null' or an empty string ' '. |
specifies a simple SELECT statement for the input table.
Requirement | The input table name must be the same in the first SELECT statement. |