foreach bankgroup in SKGN ASRIeng { use…
- User
foreach bankgroup in SKGN ASRI_eng { use "kreditrisikoanforderungen_data_makro_bankgroup'.dta"
tsset date_2 *Neue Variable(n) bzw. Anpassungen in Variablen gen kr_rest_g = kr_rwa_ksa_4_g + kr_rwa_irba_5_g + kr_rwa_irba_6_g + kr_rwa_irba_7_g + kr_rwa_ccp_g gen kr_rwa_irba_3_4_g = kr_rwa_irba_3_g + kr_rwa_irba_4_g gen kr_4_g = kr_rwa_ksa_3_g + kr_rwa_irba_3_4_g + kr_rest_g gen kr_nkmu_5_g = kr_rwa_ksa_3_g + kr_rwa_irba_3_4_g gen kr_rwa_sonst_g = kr_g - kr_nkmu_5_g - kr_rwa_ccp_g *Variablen im Verhältnis zu RWA gen kkq = t1_g / rwa_g * 100 foreach var in kr_exp_ksa kr_exp_irba kr_exp_irba_2 kr_exp_irba_sum kr_exp /// kr { gen var'q = var'_g / rwa_g * 100 } foreach var in t1 rwa /// kr_exp_ksa kr_exp_irba kr_exp_irba_2 kr_exp_irba_sum kr_exp /// kr_ksa_nkmu kr_irba_nkmu kr_irba_2_nkmu kr_irba_sum_nkmu /// kr_nkmu /// kr_rwa_ksa_3 kr_rwa_irba_3_4 /// kr_rest kr_4 /// kr /// kr_rwa_ccp /// kr_nkmu_5 kr_rwa_sonst { ************************************************************************************************************************************** gen delta_yoy_var' = (var'_g - l4.var'_g) / l4.var'_g * 100 gen delta_yoy_var'_d = (var'_g - l4.var'_g) } *KSA- und IRBA-Anteile des ursprünglichen Exposure für Kreditrisiko gen ksa_anteil = kr_exp_ksa_g / kr_exp_g * 100 gen irba_anteil = kr_exp_irba_g / kr_exp_g * 100 gen irba_2_anteil = kr_exp_irba_2_g / kr_exp_g * 100 gen irba_sum_anteil = kr_exp_irba_sum_g / kr_exp_g * 100 *RWA-Dichte gen rwa_dichte = kr_nkmu_g / kr_exp_g * 100 gen rwa_dichte_ksa = kr_ksa_nkmu_g / kr_exp_ksa_g * 100 gen rwa_dichte_irba = kr_irba_sum_nkmu_g / kr_exp_irba_sum_g * 100 *Alternative Berechnung der Anforderungen für Kreditrisiko gen kr_2_g = kr_rwa_ksa_2_g + kr_rwa_irba_sum_2_g + kr_rwa_ccp_g gen kr_3_g = kr_rwa_ksa_3_g + kr_rwa_ksa_4_g + kr_rwa_irba_3_g + kr_rwa_irba_4_g + kr_rwa_irba_5_g + kr_rwa_irba_6_g + kr_rwa_irba_7_g + kr_rwa_ccp_g *Anteile an Anforderungen für Kreditrisiko gen kr_ksa_anteil = kr_ksa_nkmu_g / kr_g * 100 gen kr_irba_anteil = kr_irba_sum_nkmu_g / kr_g * 100 gen kr_rest_anteil = kr_rest_g / kr_g * 100 ************************************************************************************************************************************** *RWA-Dichte und ihre Zerlegung: Public gen rwa_dichte_pub = kr_nkmu_pub_g / kr_exp_pub_g * 100 gen rwa_dichte_ksa_pub = kr_ksa_nkmu_pub_g / kr_exp_ksa_pub_g * 100 gen rwa_dichte_irba_pub = kr_irba_nkmu_pub_g / kr_exp_irba_pub_g * 100 *RWA-Dichte und ihre Zerlegung: Institutions gen rwa_dichte_inst = kr_nkmu_inst_g / kr_exp_inst_g * 100 gen rwa_dichte_ksa_inst = kr_ksa_nkmu_inst_g / kr_exp_ksa_inst_g * 100 gen rwa_dichte_irba_inst = kr_irba_nkmu_inst_g / kr_exp_irba_inst_g * 100 *RWA-Dichte und ihre Zerlegung: Corporates gen rwa_dichte_corp = kr_nkmu_corp_g / kr_exp_corp_g * 100 gen rwa_dichte_ksa_corp = kr_ksa_nkmu_corp_g / kr_exp_ksa_corp_g * 100 gen rwa_dichte_irba_corp = kr_irba_nkmu_corp_g / kr_exp_irba_corp_g * 100 *RWA-Dichte und ihre Zerlegung: Retail gen rwa_dichte_ret = kr_nkmu_ret_g / kr_exp_ret_g * 100 gen rwa_dichte_ksa_ret = kr_ksa_nkmu_ret_g / kr_exp_ksa_ret_g * 100 gen rwa_dichte_irba_ret = kr_irba_nkmu_ret_g / kr_exp_irba_ret_g * 100 *RWA-Dichte und ihre Zerlegung: Other gen rwa_dichte_rest = kr_nkmu_rest_g / kr_exp_rest_g * 100 gen rwa_dichte_ksa_rest = kr_ksa_nkmu_rest_g / kr_exp_ksa_rest_g * 100 gen rwa_dichte_irba_rest = kr_irba_nkmu_rest_g / kr_exp_irba_rest_g * 100 ************************************************************************************************************************************** *Anteile an Anforderungen für Kreditrisiko: Public gen kr_pub_anteil = kr_nkmu_pub_g / kr_g * 100 gen kr_pub_ksa_anteil = kr_ksa_nkmu_pub_g / kr_g * 100 gen kr_pub_irba_anteil = kr_irba_nkmu_pub_g / kr_g * 100 *Anteile an Anforderungen für Kreditrisiko: Institutions gen kr_inst_anteil = kr_nkmu_inst_g / kr_g * 100 gen kr_inst_ksa_anteil = kr_ksa_nkmu_inst_g / kr_g * 100 gen kr_inst_irba_anteil = kr_irba_nkmu_inst_g / kr_g * 100 *Anteile an Anforderungen für Kreditrisiko: Corporates gen kr_corp_anteil = kr_nkmu_corp_g / kr_g * 100 gen kr_corp_ksa_anteil = kr_ksa_nkmu_corp_g / kr_g * 100 gen kr_corp_irba_anteil = kr_irba_nkmu_corp_g / kr_g * 100 *Anteile an Anforderungen für Kreditrisiko: Retail gen kr_ret_anteil = kr_nkmu_ret_g / kr_g * 100 gen kr_ret_ksa_anteil = kr_ksa_nkmu_ret_g / kr_g * 100 gen kr_ret_irba_anteil = kr_irba_nkmu_ret_g / kr_g * 100 *Anteile an Anforderungen für Kreditrisiko: Other gen kr_other_anteil = kr_nkmu_rest_g / kr_g * 100 gen kr_other_ksa_anteil = kr_ksa_nkmu_rest_g / kr_g * 100 gen kr_other_irba_anteil = kr_irba_nkmu_rest_g / kr_g * 100 ************************************************************************************************************************************** *Anteile an ursprünglichem Exposure für Kreditrisiko: Public gen kr_exp_pub_anteil = kr_exp_pub_g / kr_exp_g * 100 gen kr_exp_pub_ksa_anteil = kr_exp_ksa_pub_g / kr_exp_g * 100 gen kr_exp_pub_irba_anteil = kr_exp_irba_pub_g / kr_exp_g * 100 *Anteile an ursprünglichem Exposure für Kreditrisiko: Institutions gen kr_exp_inst_anteil = kr_exp_inst_g / kr_exp_g * 100 gen kr_exp_inst_ksa_anteil = kr_exp_ksa_inst_g / kr_exp_g * 100 gen kr_exp_inst_irba_anteil = kr_exp_irba_inst_g / kr_exp_g * 100 *Anteile an ursprünglichem Exposure für Kreditrisiko: Corporates gen kr_exp_corp_anteil = kr_exp_corp_g / kr_exp_g * 100 gen kr_exp_corp_ksa_anteil = kr_exp_ksa_corp_g / kr_exp_g * 100 gen kr_exp_corp_irba_anteil = kr_exp_irba_corp_g / kr_exp_g * 100 *Anteile an ursprünglichem Exposure für Kreditrisiko: Retail gen kr_exp_ret_anteil = kr_exp_ret_g / kr_exp_g * 100 gen kr_exp_ret_ksa_anteil = kr_exp_ksa_ret_g / kr_exp_g * 100 gen kr_exp_ret_irba_anteil = kr_exp_irba_ret_g / kr_exp_g * 100 *Anteile an ursprünglichem Exposure für Kreditrisiko: Other gen kr_exp_other_anteil = kr_exp_rest_g / kr_exp_g * 100 gen kr_exp_other_ksa_anteil = kr_exp_ksa_rest_g / kr_exp_g * 100 gen kr_exp_other_irba_anteil = kr_exp_irba_rest_g / kr_exp_g * 100 *Anteile an ursprünglichem Exposure für Kreditrisiko innerhalb von KSA bzw. IRBA foreach var1 in pub inst corp ret other { if "var1'" != "other" { local var2 = "var1'" } else if "var1'" == "other" { local var2 = "rest" } gen kr_exp_var1'_anteil_in_ksa = kr_exp_ksa_var2'_g / kr_exp_ksa_g * 100 gen kr_exp_var1'_anteil_in_irba = kr_exp_irba_var2'_g / kr_exp_irba_sum_g * 100 } *Veränderung der Anteile foreach var in pub inst corp ret other { *KR-Anteile an den RWA gen delta_kr_var'_anteil = kr_var'_anteil - l4.kr_var'_anteil gen delta_kr_var'_ksa_anteil = kr_var'_ksa_anteil - l4.kr_var'_ksa_anteil gen delta_kr_var'_irba_anteil = kr_var'_irba_anteil - l4.kr_var'_irba_anteil *KR-Anteile an ursprünglichem Exposure gen delta_kr_exp_var'_ant = kr_exp_var'_anteil - l4.kr_exp_var'_anteil ************************************************************************************************************************************** gen delta_kr_exp_var'_ksa_ant = kr_exp_var'_ksa_anteil - l4.kr_exp_var'_ksa_anteil gen delta_kr_exp_var'_irba_ant = kr_exp_var'_irba_anteil - l4.kr_exp_var'_irba_anteil } gen delta_kr_rest_anteil = kr_rest_anteil - l4.kr_rest_anteil *Alternative Berechnung der Anforderungen für Kreditrisiken nach IRBA/KSA: *Cross-check ob kr_nkmu_g = kr_nkmu_2_g gilt *Cross-check: Generierung von kr_exp_2_g für die Berechnung der Risikodichte nur für das Aggregat des Teils der Kreditrisikoanforderungen, der für die Zerlegung unten relevant ist gen kr_nkmu_2_g = 0 gen kr_nkmu_3_g = 0 gen kr_exp_2_g = 0 foreach var1 in pub inst corp ret other { foreach var3 in irba ksa { if "var1'" != "other" { local var2 = "var1'" } else if "var1'" == "other" { local var2 = "rest" } ************************************************************************************************************************************** replace rwa_dichte_var3'_var2' = 0 if rwa_dichte_var3'_var2' == . replace kr_nkmu_2_g = kr_nkmu_2_g + kr_exp_g * kr_exp_var1'_var3'_anteil * rwa_dichte_var3'_var2' ************************************************************************************************************************************** replace kr_nkmu_3_g = kr_nkmu_3_g + kr_exp_var1'_var3'_anteil * rwa_dichte_var3'_var2' replace kr_exp_2_g = kr_exp_2_g + kr_exp_g * kr_exp_var1'_var3'_anteil / 100 } } *Zerlegung der Veränderung der Anforderungen für Kreditrisiken nach IRBA/KSA ************************************************************************************************************************************** sort date_2 gen anteil_vol = kr_nkmu_3_g / l4.kr_nkmu_3_g * delta_yoy_kr_exp // Volumeneffekt gen anteil_vol_2 = delta_yoy_kr_exp // Volumeneffekt gen anteil_vol_3 = delta_yoy_kr_exp // Volumeneffekt gen anteil_dekomp = 0 // Portfolioumschichtungseffekt gen anteil_dekomp_2 = 0 // Portfolioumschichtungseffekt gen anteil_dekomp_3 = 0 // Portfolioumschichtungseffekt gen anteil_rwa_dichte = 0 // Effekt der Veränderung der RWA-Dichte gen anteil_rwa_dichte_2 = 0 // Effekt der Veränderung der RWA-Dichte gen anteil_rwa_dichte_3 = 0 // Effekt der Veränderung der RWA-Dichte foreach var1 in pub inst corp ret other { foreach var3 in irba ksa { if "var1'" != "other" { local var2 = "var1'" } else if "var1'" == "other" { local var2 = "rest" } sort date_2 ************************************************************************************************************************************** replace anteil_dekomp = anteil_dekomp + rwa_dichte_var3'_var2' * delta_kr_exp_var1'_var3'_ant / l4.kr_nkmu_3_g replace anteil_dekomp_2 = anteil_dekomp_2 + kr_exp_g / l4.kr_exp_g * rwa_dichte_var3'_var2' * delta_kr_exp_var1'_var3'_ant / l4.kr_nkmu_3_g replace anteil_dekomp_3 = anteil_dekomp_3 + kr_exp_g / l4.kr_exp_g * l4.rwa_dichte_var3'_var2' * delta_kr_exp_var1'_var3'_ant / l4.kr_nkmu_3_g gen anteil_dekomp_var3'_var2' = rwa_dichte_var3'_var2' * delta_kr_exp_var1'_var3'_ant / l4.kr_nkmu_3_g * 100 gen anteil_dekomp_var3'_var2'_2 = kr_exp_g / l4.kr_exp_g * rwa_dichte_var3'_var2' * delta_kr_exp_var1'_var3'_ant / l4.kr_nkmu_3_g * 100 gen anteil_dekomp_var3'_var2'_3 = kr_exp_g / l4.kr_exp_g * l4.rwa_dichte_var3'_var2' * delta_kr_exp_var1'_var3'_ant / l4.kr_nkmu_3_g * 100 gen anteil_dekomp_var3'_var2'_mw = (anteil_dekomp_var3'_var2' + anteil_dekomp_var3'_var2'_2 + anteil_dekomp_var3'_var2'_3) / 3 gen delta_rwa_dichte_var3'_var2' = rwa_dichte_var3'_var2' - l4.rwa_dichte_var3'_var2' replace delta_rwa_dichte_var3'_var2' = 0 if delta_rwa_dichte_var3'_var2' == . ************************************************************************************************************************************** replace anteil_rwa_dichte = anteil_rwa_dichte + delta_rwa_dichte_var3'_var2' * l4.kr_exp_var1'_var3'_ant / l4.kr_nkmu_3_g replace anteil_rwa_dichte_2 = anteil_rwa_dichte_2 + kr_exp_g / l4.kr_exp_g * delta_rwa_dichte_var3'_var2' * l4.kr_exp_var1'_var3'_ant / l4.kr_nkmu_3_g replace anteil_rwa_dichte_3 = anteil_rwa_dichte_3 + kr_exp_g / l4.kr_exp_g * delta_rwa_dichte_var3'_var2' * kr_exp_var1'_var3'_ant / l4.kr_nkmu_3_g gen anteil_rwa_dichte_var3'_var2' = delta_rwa_dichte_var3'_var2' * l4.kr_exp_var1'_var3'_ant / l4.kr_nkmu_3_g gen anteil_rwa_dichte_var3'_var2'_2 = kr_exp_g / l4.kr_exp_g * delta_rwa_dichte_var3'_var2' * l4.kr_exp_var1'_var3'_ant / l4.kr_nkmu_3_g gen anteil_rwa_dichte_var3'_var2'_3 = kr_exp_g / l4.kr_exp_g * delta_rwa_dichte_var3'_var2' * kr_exp_var1'_var3'_ant / l4.kr_nkmu_3_gin the last line kr_exp_var1'_var3'_ant is referred to, but i dont see where this is defined anywhere please help for example kr_exp_pub_ksa_ant i dont see anything with just the ending _ant
Assistant
Okay, let's break down where those variables are defined and clarify the naming convention.
You are looking at the section where changes (deltas) are calculated, specifically:
*Anteile an ursprünglichem Exposure für Kreditrisiko: Public gen kr_exp_pub_anteil = kr_exp_pub_g / kr_exp_g * 100 gen kr_exp_pub_ksa_anteil = kr_exp_ksa_pub_g / kr_exp_g * 100 gen kr_exp_pub_irba_anteil = kr_exp_irba_pub_g / kr_exp_g * 100 *Anteile an ursprünglichem Exposure für Kreditrisiko: Institutions gen kr_exp_inst_anteil = kr_exp_inst_g / kr_exp_g * 100 gen kr_exp_inst_ksa_anteil = kr_exp_ksa_inst_g / kr_exp_g * 100 gen kr_exp_inst_irba_anteil = kr_exp_irba_inst_g / kr_exp_g * 100 *... and so on for corp, ret, other (mapped to rest) ... *Anteile an ursprünglichem Exposure für Kreditrisiko: Other gen kr_exp_other_anteil = kr_exp_rest_g / kr_exp_g * 100 gen kr_exp_other_ksa_anteil = kr_exp_ksa_rest_g / kr_exp_g * 100 gen kr_exp_other_irba_anteil = kr_exp_irba_rest_g / kr_exp_g * 100This block defines the base variables for the "shares of original exposure". Notice the naming pattern:
kr_exp_[category]_[segment]_anteil.[category]ispub,inst,corp,ret,other.[segment]is the base (_gvariables divided bykr_exp_g), orksa(likekr_exp_ksa_pub_g), orirba(likekr_exp_irba_pub_g).anteilis the suffix meaning "share".
Now, let's look at the loop where you found the reference:
*Veränderung der Anteile foreach var in pub inst corp ret other { *KR-Anteile an den RWA gen delta_kr_var'_anteil = kr_var'_anteil - l4.kr_var'_anteil gen delta_kr_var'_ksa_anteil = kr_var'_ksa_anteil - l4.kr_var'_ksa_anteil gen delta_kr_var'_irba_anteil = kr_var'_irba_anteil - l4.kr_var'_irba_anteil *KR-Anteile an ursprünglichem Exposure gen delta_kr_exp_var'_ant = kr_exp_var'_anteil - l4.kr_exp_var'_anteil ************************************************************************************************************************************** gen delta_kr_exp_var'_ksa_ant = kr_exp_var'_ksa_anteil - l4.kr_exp_var'_ksa_anteil gen delta_kr_exp_var'_irba_ant = kr_exp_var'_irba_anteil - l4.kr_exp_var'_irba_anteil }Here, the
foreachloop iterates throughpub,inst,corp,ret,other. Inside the loop, the macrovartakes on these values.- The lines like
gen delta_kr_exp_var'_antare intended to create variables likedelta_kr_exp_pub_anteil,delta_kr_exp_inst_anteil, etc. They use the variables defined in the block above (likekr_exp_pub_anteil,kr_exp_inst_anteil). - The specific line you're asking about is
gen delta_kr_exp_var'_ksa_ant = kr_exp_var'_ksa_anteil - l4.kr_exp_var'_ksa_anteil.- When
varispub, this line effectively becomes:gen delta_kr_exp_pub_ksa_ant = kr_exp_pub_ksa_anteil - l4.kr_exp_pub_ksa_anteil - When
varisinst, it becomes:gen delta_kr_exp_inst_ksa_ant = kr_exp_inst_ksa_anteil - l4.kr_exp_inst_ksa_anteil - And so on.
- When
The source variables (
kr_exp_pub_ksa_anteil,kr_exp_inst_ksa_anteil, etc.) were defined in the block before this loop, as shown earlier.Why the confusion?
- Naming Convention: The code seems to use
_antas a shorthand or potentially a typo for_anteilwhen creating the delta variables. - Dynamic Naming: The
foreachloop combined with thevarmacro dynamically generates the variable names. The code refers tokr_exp_var'_ksa_anteilwithin the loop, which correctly resolves to the specific variables defined earlier (likekr_exp_pub_ksa_anteil,kr_exp_inst_ksa_anteil, etc.) based on the current value ofvar.
In summary: The variables like
kr_exp_pub_ksa_anteil,kr_exp_inst_ksa_anteil,kr_exp_pub_irba_anteil, etc., are defined in the section calculating "Anteile an ursprünglichem Exposure für Kreditrisiko" (Shares of original exposure for credit risk). The loop then uses these defined variables to calculate the year-over-year changes (deltas), creating new variables often suffixed with_ant.
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.