@ks94 wrote:
it's done!
it's in .txt
Just PASTE the lines from the file into the box that opens when you click on the INSERT CODE icon (it now looks like < / >.
case;cc3;country;year;systemic_crisis;exch_usd;domestic_debt_in_default;sovereign_external_debt_default;gdp_weighted_default;inflation_annual_cpi;independence;currency_crises;inflation_crises;banking_crisis
45;NGA;Nigeria;2014;1;155,25;0;0;0;8,048;1;0;0;crisis
1;DZA;Algeria;1871;0;0,052798;0;0;0;14,14913958;0;0;0;no_crisis
1;DZA;Algeria;1872;0;0,052274;0;0;0;-3,718592965;0;0;0;no_crisis
1;DZA;Algeria;1873;0;0,05168;0;0;0;11,20389701;0;0;0;no_crisis
1;DZA;Algeria;1874;0;0,051308;0;0;0;-3,848560701;0;0;0;no_crisis
The file is NOT a Comma Separated Values file. It is a delimited file with semi-colon as the delimiter. The reason PROC IMPORT thought there were only three variables is because the maximum number of commas in any of the lines was 2. Just tell PROC IMPORT what character to use as the delimiter.
... View more