34%macro irmst_load_tm_analysis_data(ad_analysis_data_name = %quote(Transition Matrix Results)
35 , ad_analysis_data_desc = %quote(Transition Matrix Results from Segment-level Analysis Run. \nCreated by user &_metauser. on %sysfunc(datetime(), nldatmw200.).)
36 , ad_analysis_run_id =
42 , ad_meta_library_name = SAS Stress Testing Data Repository
45 , in_model_group_map =
46 , in_model_tm_results =
65 %
if %qupcase(&debug) in (Y YES 1 TRUE) %then
74 create table work._out_tm_results_upload as
75 select b.modeling_system_name label=
"Modeling System Name",
76 b.modeling_system_version label=
"Modeling System Version",
77 b.model_group_name label=
"Modeling System Group name",
78 c.bepname as business_evolution_plan_name label=
"Business Evolution Plan Name",
79 c.mrsname as master_risk_scenario_name label=
"Master Risk Scenario Name",
80 c.scenarioid as mip_scenario_name label=
"MIP Scenario Name",
83 a.from_risk_rating label=
"From Risk Rating",
84 a.to_risk_rating label=
"Migrated Risk Rating",
85 a.pd_value as transition_probabilities label=
"Transition Probabilities",
86 a.order_num label=
"Order Number"
87 from &in_model_tm_results as a,
88 &in_model_group_map as b,
89 (select distinct scenarioid,
93 from &in_scenario_meta) as c
94 where a.model_group_sk eq b.model_group_sk and
95 upcase(a.insttype) eq upcase(b.insttype) and
96 a.scenario_sk eq c.mrskey
103 %let httpSuccess = 0;
104 %let responseStatus = ;
105 %let ticket_tm_upload = ;
106 %let filterable_vars = model_group_name insttype master_risk_scenario_name valuation_date from_risk_rating to_risk_rating;
108 %irm_rgf_store_analysis_data(ds_in = work._out_tm_results_upload
110 , analysis_data_name = %superq(ad_analysis_data_name)
111 , analysis_data_desc = %superq(ad_analysis_data_desc)
112 , base_date = &ad_base_date.
113 , cycle_id = &ad_cycle_id.
114 , status_cd = Preliminary
115 , visibility_cd = Private
116 , analysis_run_id = &ad_analysis_run_id.
118 , data_definition_name = Transition Matrix Results
119 , data_definition_desc = TM Schema Definition
120 , libref = &ad_libref.
121 , meta_library_name = &ad_meta_library_name.
122 , schema_name = ST_TM_RES
123 , schema_version = &ad_schema_version.
125 , business_category = STM
126 , data_category = RESULTS
128 , filterable_vars = &filterable_vars.
131 , load_id = Production
132 , entity_id = &ad_entity_id.
133 , constraint_enabled_flg = Y
134 , details_root = &ad_details_root.
135 , details_app = SASStressTesting
137 , out_exceptions = work._tm_upload_exceptions
138 , out_analysis_data = work._tm_upload_analysis_data
139 , out_partition_list = work._tm_upload_partition_list
140 , out_data_definition = work._tm_upload_data_definition
141 , out_link_instance = work._tm_upload_link_instance
143 , host = &rgf_protocol.:
144 , server = &rgf_service.
145 , solution = &rgf_solution.
147 , tgt_ticket = %superq(tgt_ticket)
148 , outVarTicket = ticket_tm_upload
149 , outSuccess = httpSuccess
150 , outResponseStatus = responseStatus
156 %if %qupcase(&_debug_.) eq NO %then
159 drop table work._out_tm_results_upload,
160 work._tm_upload_exceptions,
161 work._tm_upload_analysis_data,
162 work._tm_upload_partition_list,
163 work._tm_upload_data_definition,
164 work._tm_upload_link_instance
169%mend irmst_load_tm_analysis_data;