扫码加入数据分析学习群

我有两组月度数据，一边里面的year month是字符型Length 12., Format12,informat12.。另一个是数值型length 8 Format Best12.,informat Best32.这两个要怎么转换成一个类型然后用merge呢？

data a1;
input a b @@;
cards;
23 45 34 34 54 34
;
run;
data _null_;
set a1;
array tmp[*] _character_;
call symputx("nvar",dim(tmp));
run;

data tmp;
set a1 end=eof;
array tmp[*] _character_;
length vars $ 32767;
retain vars "";
array num[&nvar.];
do i=1 to dim(tmp);
num[i]=input(tmp[i],best.);
if eof then vars=catx(" ",vars,cats(vname(num[i]),"=",vname(tmp[i])));
end;
if eof then call symputx ("vars",vars);
drop _character_ i;
run;

data a4;
set tmp;
rename &vars.;
run;

proc contents data=a4; title "字符型批量变成数字型"; run;