67CREATE TABLE &LIBREF..MARKET_YEAR_ECONOMIC_SIM (
68 REPORTING_DT DATE label =
'' FORMAT = &DTFMT.,
69 _date_ DATE label =
'' FORMAT = &DTFMT.,
70 simulationreplication NUMERIC(8) label =
'',
71 simulationtime NUMERIC(8) label =
'',
72 USD_CAD NUMERIC(8) label =
'',
73 USD_JPY NUMERIC(8) label =
'',
74 USD_EUR NUMERIC(8) label =
'',
75 USD_BRL NUMERIC(8) label =
'',
76 USD_CNH NUMERIC(8) label =
'',
77 USD_KRW NUMERIC(8) label =
'',
78 USD_TWD NUMERIC(8) label =
'',
79 USD_AUD NUMERIC(8) label =
'',
80 USD_HKD NUMERIC(8) label =
'',
81 EUR_USD NUMERIC(8) label =
'',
82 equity_440_hk NUMERIC(8) label =
'',
83 equity_173_hk NUMERIC(8) label =
'',
84 usd1mlib NUMERIC(8) label =
'',
85 usd3mlib NUMERIC(8) label =
'',
86 usd6mlib NUMERIC(8) label =
'',
87 usd1ylib NUMERIC(8) label =
'',
88 usd2ylib NUMERIC(8) label =
'',
89 usd3ylib NUMERIC(8) label =
'',
90 usd5ylib NUMERIC(8) label =
'',
91 usd10ylib NUMERIC(8) label =
'',
92 usd15ylib NUMERIC(8) label =
'',
93 usd20ylib NUMERIC(8) label =
'',
94 usd30ylib NUMERIC(8) label =
'',
95 jpy1mlib NUMERIC(8) label =
'',
96 jpy3mlib NUMERIC(8) label =
'',
97 jpy6mlib NUMERIC(8) label =
'',
98 jpy1ylib NUMERIC(8) label =
'',
99 jpy2ylib NUMERIC(8) label =
'',
100 jpy3ylib NUMERIC(8) label =
'',
101 jpy5ylib NUMERIC(8) label =
'',
102 jpy10ylib NUMERIC(8) label =
'',
103 jpy15ylib NUMERIC(8) label =
'',
104 jpy20ylib NUMERIC(8) label =
'',
105 jpy30ylib NUMERIC(8) label =
'',
106 eur1mlib NUMERIC(8) label =
'',
107 eur3mlib NUMERIC(8) label =
'',
108 eur6mlib NUMERIC(8) label =
'',
109 eur1ylib NUMERIC(8) label =
'',
110 eur2ylib NUMERIC(8) label =
'',
111 eur3ylib NUMERIC(8) label =
'',
112 eur5ylib NUMERIC(8) label =
'',
113 eur10ylib NUMERIC(8) label =
'',
114 eur15ylib NUMERIC(8) label =
'',
115 eur20ylib NUMERIC(8) label =
'',
116 eur30ylib NUMERIC(8) label =
'',
117 CONSTRAINT PRIM_KEY PRIMARY KEY (REPORTING_DT, _DATE_, SIMULATIONREPLICATION, SIMULATIONTIME)