26%macro irmst_recombine_bep(IN_DS_NM = ,
36 %let in_lib=%scan(&IN_DS_NM,1,
'.');
37 %let out_lib=%scan(&O_DS, 1,
'.');
41 into: scenario_names separated by
','
42 from &DS_IN_BSP_CONFIG;
44 create table &O_DS. as
45 select dataDefSchemaName as tbl_name,
46 "&scenario_names." as scenario_name,
47 "&out_lib." as tbl_lib
48 from &DS_IN_BEP_SUMMARY.;
52 select tbl_name into: tbls_names separated by
','
58 do indx=1 to countw(
"&tbls_names",
',');
59 tbl_name=scan(
"&tbls_names.",indx,
',');
60 call symputx(cats(
'tbl_nm_',indx),tbl_name);
64%
do indx=1 %to %sysfunc(countw(
"&tbls_names",
','));
68 %
do i=1 %to &PARTITION_NO;
69 &LIB_PREFIX.&i..&&tbl_nm_&indx..
77 proc append base =&out_lib..&&tbl_nm_&indx.. data=temp;