hi I add my code to allow you to better understand my concern. /*creer la bibliotheque*/
libname Prep "/folders/myfolders";
/*1-importer les données*/
proc import
datafile="/folders/myfolders/Data_projet_AFRIQUE.csv"
out=Prep.AFRICA
replace;
getnames=yes;
delimiter=';';
guessingrows=max;
run;
/*rename the variables */
data PREP.AFRICA;
set PREP.AFRICA (rename=(case=ID_PAYS cc3=ID_PAYS_CC3 country=PAYS
year=ANNEE systemic_crisis=FLAG_CRISE_SYSTEMIQUE exch_usd=TAUX_CHANGE_USD
domestic_debt_in_default=FLAG_DETTE_INTERIEURE sovereign_external_debt_default=FLAG_DETTE_EXTERIEURE
gdp_weighted_default=TOTAL_DETTE_PIB inflation_annual_cpi=TAUX_INFLATION
independence=FLAG_INDEPENDANCE currency_crises=FLAG_CRISE_MONETAIRE
inflation_crises=FLAG_CRISE_INFLATION banking_crisis=FLAG_CRISE_BANCAIRE
));
run;
/* I change the type of some variables*/
* numeriques à caracteres*/
data prep.africa;
set prep.africa;
char_FLAG_CRISE_INFLATION = put(FLAG_CRISE_INFLATION, $15.) ;
char_FLAG_CRISE_MONETAIRE = put(FLAG_CRISE_MONETAIRE, $15.) ;
char_FLAG_CRISE_SYSTEMIQUE = put(FLAG_CRISE_SYSTEMIQUE, $15.) ;
char_FLAG_DETTE_EXTERIEURE = put(FLAG_DETTE_EXTERIEURE, $15.) ;
char_FLAG_DETTE_INTERIEURE = put(FLAG_DETTE_INTERIEURE, $15.) ;
char_FLAG_INDEPENDANCE = put(FLAG_INDEPENDANCE, $15.) ;
drop FLAG_CRISE_INFLATION;
drop FLAG_CRISE_MONETAIRE ;
drop FLAG_CRISE_SYSTEMIQUE ;
drop FLAG_DETTE_EXTERIEURE ;
drop FLAG_DETTE_INTERIEURE ;
drop FLAG_INDEPENDANCE ;
rename char_FLAG_CRISE_MONETAIRE=FLAG_CRISE_MONETAIRE ;
rename char_FLAG_CRISE_INFLATION=FLAG_CRISE_INFLATION;
rename char_FLAG_CRISE_SYSTEMIQUE=FLAG_CRISE_SYSTEMIQUE;
rename char_FLAG_DETTE_EXTERIEURE=FLAG_DETTE_EXTERIEURE;
rename char_FLAG_DETTE_INTERIEURE=FLAG_DETTE_INTERIEURE;
rename char_FLAG_INDEPENDANCE=FLAG_INDEPENDANCE;
run;
/* caracteres à numeriques */
data prep.africa;
set prep.africa;
Num_FLAG_CRISE_BANCAIRE = input(FLAG_CRISE_BANCAIRE,best1. ) ;
Num_TAUX_CHANGE_USD = input(TAUX_CHANGE_USD,best1. ) ;
drop FLAG_CRISE_BANCAIRE;
drop TAUX_CHANGE_USD;
rename Num_FLAG_CRISE_BANCAIRE=FLAG_CRISE_BANCAIRE;
rename Num_TAUX_CHANGE_USD=TAUX_CHANGE_USD;
run;
/*Now I want ton cross the character variable*/ /* which are FLAG_CRISE_MONETAIRE FLAG_CRISE_INFLATION FLAG_INDEPENDANCE FLAG_DETTE_EXTERIEURE FLAG_DETTE_INTERIEURE*FLAG_CRISE_SYSTEMIQUE */ Thanks
... View more