/*导入GDP同比增长比例*/
data a;
set lending.ITdata;
run;
data null;
set a;
a='%Seasongdpratecomp(';
b=',';
c=');';
file "D:\data\YTM\txt\Seasongdpratecomp.txt";
m=a||code||b||sintdate||b||Tdate||b||province||b||rate||b||typeflg||b||D||c;
put m;
run;
data a;
delete;
data a1;
delete;
data a2;
delete;
data b;
delete;
data c;
delete;
run;
%macro Seasongdpratecomp(code,sintdate,Tdate,province,rate,typeflg,D);
data a1;
set lending.Seasongdprate;
if province=&province;
if date<=&Tdate;
SGdprate=SeasonGDPrate/100;
Tdate=&Tdate;
code=&code;
keep pos code date tdate province Sgdprate;
run;
proc sort data=a1;
by date;
run;
data a2;
set a1 end=lasobs;
if lasobs;
run;
data b;
set b a2;
run;
%mend Seasongdpratecomp;
%include "D:\data\YTM\txt\Seasongdpratecomp.txt";
run;
data lending.finGDP;
set b;
run;
ITdata 和 Seasongdprate(见附件)中变量Province 是中文字符,如安徽,黑龙江等,我的原意是如果省份相同,就查找GDP增长的变量,但这样直接引用出现错误,求怎样才能实现我的想法?谢谢!