Thank you for understanding. Faced the following problem. If you substitute the% NRBQUOTE function in LOAD_PARAM, then sas passes CELL_PACKAGE_SK one by one, and this is not what I need. I would like sas to pass CELL_PACKAGE_SK parameters in one line. An example from the log how the process works now: MLOGIC(LOAD_PARAMS): Beginning execution. SYMBOLGEN: Macro variable CELL_PACKAGE_SK resolves to 102118,102119 MLOGIC(LOAD_PARAMS): Parameter CELL_PACKAGE_SK has value 102118102119 SYMBOLGEN: Macro variable CELL_PACKAGE_SK resolves to 102118,102119 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. MLOGIC(LOAD_PARAMS): %DO loop beginning; index variable I; start value is 1; stop value is 2; by value is 1. MLOGIC(LOAD_PARAMS): %LET (variable name is STR) SYMBOLGEN: Macro variable CELL_PACKAGE_SK resolves to 102118,102119 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. SYMBOLGEN: Macro variable I resolves to 1 MPRINT(LOAD_PARAMS): proc sql noprint; MPRINT(LOAD_PARAMS): connect to oracle (AuthDomain="Oracle_Auth" PATH="@sas-te-list.or:1111/CRM"); NOTE: Credential obtained from SAS metadata server. SYMBOLGEN: Macro variable STR resolves to 102118 MPRINT(LOAD_PARAMS): execute ( begin exchange.pck_params.pr_params_sto_load(102118); MPRINT(LOAD_PARAMS): end; MPRINT(LOAD_PARAMS): ) by oracle; MPRINT(LOAD_PARAMS): disconnect from oracle; MPRINT(LOAD_PARAMS): quit; MLOGIC(LOAD_PARAMS): %DO loop index variable I is now 2; loop will iterate again. MLOGIC(LOAD_PARAMS): %LET (variable name is STR) SYMBOLGEN: Macro variable CELL_PACKAGE_SK resolves to 102118,102119 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. SYMBOLGEN: Macro variable I resolves to 2 MPRINT(LOAD_PARAMS): proc sql noprint; MPRINT(LOAD_PARAMS): connect to oracle (AuthDomain="Oracle_Auth" PATH="@sas-te-list.or:1111/CRM"); NOTE: Credential obtained from SAS metadata server. SYMBOLGEN: Macro variable STR resolves to 102119 MPRINT(LOAD_PARAMS): execute ( begin exchange.pck_params.pr_params_sto_load(102119); MPRINT(LOAD_PARAMS): end; MPRINT(LOAD_PARAMS): ) by oracle; MPRINT(LOAD_PARAMS): disconnect from oracle; MPRINT(LOAD_PARAMS): quit; The question is the same, how to pass CELL_PACKAGE_SK parameters to Oracle in one line from sas. ... View more

I apologize, your decision was also correct. But not obvious to me. My fault ... View more

Good day. Thank you all for your active help. But the solution was unexpected. Because When calling% Load_params, a delimited error occurred. Then we used the% NRBQUOTE function Example: % Load_Params (CELL_PACKAGE_SK =% NRBQUOTE (& CELL_PACKAGE_SK.)); ... View more

It really helps, but the problem arises already at the Oracle level, the database understands nothing but a comma separator. Therefore, I turned here for help thanks for the advice ... View more

I considered the option of replacing the separator in place of the comma put the underscore. But this method does not work in Oracle. Oracle most often uses comma delimiter   Thank you for your interest ... View more

Tell me, please, where do you need to fix it? i don't get it ... View more