在sas运行时，用merge合并之后，会出现很多重复值，现在代码如下不知道哪里错了：/*调入工作状态*/
data age;
set SYC.age;
run;
data dbdbum;
set SYC.dbdbum;
run;
data degree;
set SYC.degree;
run;
data earings;
set SYC.earings;
run;
data lev;
set SYC.lev;
run;
data presmn;
set SYC.presmn;
run;
data quality;
set SYC.quality;
run;
data revenuerate;
set SYC.revenuerate;
run;
data roa;
set SYC.roa;
run;
data sex;
set SYC.sex;
run;
data size;
set SYC.size;
run;
data big;
set SYC.big;
run;
data tenure;
set SYC.tenure;
run;


/*合并数据集*/
/*1.删除季度值 取出股票代码*/
data age;
set age;
month=substr(year,6,2);
year=substr(year,1,4);
run;
data dbdbum;
set dbdbum;
month=substr(year,6,2);
year=substr(year,1,4);
run;
data degree;
set degree;
month=substr(year,6,2);
year=substr(year,1,4);
run;
data earings;
set earings;
month=substr(year,6,2);
year=substr(year,1,4);
run;
data lev;
set lev;
month=substr(year,6,2);
year=substr(year,1,4);
run;
data presmn;
set presmn;
month=substr(year,6,2);
year=substr(year,1,4);
run;
data revenuerate;
set revenuerate;
month=substr(year,6,2);
year=substr(year,1,4);
run;
data roa;
set roa;
month=substr(year,6,2);
year=substr(year,1,4);
run;
data sex;
set sex;
month=substr(year,6,2);
year=substr(year,1,4);
run;
data size;
set size;
month=substr(year,6,2);
year=substr(year,1,4);
run;
data big;
set big;
month=substr(year,6,2);
year=substr(year,1,4);
run;
data tenure;
set tenure;
month=substr(year,6,2);
year=substr(year,1,4);
run;




/*2.选取合并变量，统一合并变量的格式,age rate education earingspershare lev presmn result result1 growthrateoftotalrevenue roa sex logarithmoftotalassets totalassets  tenure*/
data age;
set age;
code1=input(code,best12.);
year1=input(year,best12.);
run;
data age;
set age;
drop code year;
rename code1=code;
rename year1=year;
run;
data dbdbum;
set dbdbum;
code1=input(code,best12.);
year1=input(year,best12.);
run;
data dbdbum;
set dbdbum;
drop code year;
rename code1=code;
rename year1=year;
run;
data degree;
set degree;
code1=input(code,best12.);
year1=input(year,best12.);
run;
data degree;
set degree;
drop code year;
rename code1=code;
rename year1=year;
run;
data earings;
set earings;
code1=input(code,best12.);
year1=input(year,best12.);
run;
data earings;
set earings;
drop code year;
rename code1=code;
rename year1=year;
run;
data lev;
set lev;
code1=input(code,best12.);
year1=input(year,best12.);
run;
data lev;
set lev;
drop code year;
rename code1=code;
rename year1=year;
run;
data presmn;
set presmn;
code1=input(code,best12.);
year1=input(year,best12.);
run;
data presmn;
set presmn;
drop code year;
rename code1=code;
rename year1=year;
run;
data quality;
set quality;
code1=input(code,best12.);
year1=input(year,best12.);
run;
data quality;
set quality;
drop code year;
rename code1=code;
rename year1=year;
run;
data revenuerate;
set revenuerate;
code1=input(code,best12.);
year1=input(year,best12.);
run;
data revenuerate;
set revenuerate;
drop code year;
rename code1=code;
rename year1=year;
run;
data roa;
set roa;
code1=input(code,best12.);
year1=input(year,best12.);
run;
data roa;
set roa;
drop code year;
rename code1=code;
rename year1=year;
run;
data sex;
set sex;
code1=input(code,best12.);
year1=input(year,best12.);
run;
data sex;
set sex;
drop code year;
rename code1=code;
rename year1=year;
run;
data size;
set size;
code1=input(code,best12.);
year1=input(year,best12.);
run;
data size;
set size;
drop code year;
rename code1=code;
rename year1=year;
run;
data big;
set big;
code1=input(code,best12.);
year1=input(year,best12.);
run;
data big;
set big;
drop code year;
rename code1=code;
rename year1=year;
run;
data tenure;
set tenure;
code1=input(code,best12.);
year1=input(year,best12.);
run;
data tenure;
set tenure;
drop code year;
rename code1=code;
rename year1=year;
run;


/*3.依据合并变量排序*/
proc sort data=age;
by code year;
run;
proc sort data=dbdbum;
by code year;
run;
proc sort data=degree;
by code year;
run;
proc sort data=earings;
by code year;
run;
proc sort data=lev;
by code year;
run;
proc sort data=presmn;
by code year;
run;
proc sort data=quality;
by code year;
run;
proc sort data=revenuerate;
by code year;
run;
proc sort data=roa;
by code year;
run;
proc sort data=sex;
by code year;
run;
proc sort data=size;
by code year;
run;
proc sort data=big;
by code year;
run;
proc sort data=tenure;
by code year;
run;

/*4.合并*/
data total;
merge age dbdbum degree earings lev presmn quality revenuerate roa sex size big tenure;
by code year;
run;