这个winzorize/delete的宏貌似不对啊

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

我选择type=delete  结果没有删我任何数据   我的调用如下：

%winsor(dsetin=intern.compustat_patent_hhi1, dsetout=intern.compustat_patent_hhi11, byvar=none,vars=hhi fic300hhi tnic3hhi, type=delete, pctl=97.5);

http://www.wrds.us/index.php/repository/view/1

/***************************************** Trim or winsorize macro * byvar = none for no byvar; * type  = delete/winsor (delete will trim, winsor will winsorize; *dsetin = dataset to winsorize/trim; *dsetout = dataset to output with winsorized/trimmed values; *byvar = subsetting variables to winsorize/trim on; ****************************************/    %macro winsor(dsetin=, dsetout=, byvar=none, vars=, type=winsor, pctl=1 99);    %if &dsetout = %then %let dsetout = &dsetin;       %let varL=; %let varH=; %let xn=1;    %do %until ( %scan(&vars,&xn)= );     %let token = %scan(&vars,&xn);     %let varL = &varL &token.L;     %let varH = &varH &token.H;     %let xn=%EVAL(&xn + 1); %end;    %let xn=%eval(&xn-1);    data xtemp;     set &dsetin;     run;    %if &byvar = none %then %do;        data xtemp;         set xtemp;         xbyvar = 1;         run;        %let byvar = xbyvar;    %end;    proc sort data = xtemp;     by &byvar;     run;    proc univariate data = xtemp noprint;     by &byvar;     var &vars;     output out = xtemp_pctl PCTLPTS = &pctl PCTLPRE = &vars PCTLNAME = L H;     run;    data &dsetout;     merge xtemp xtemp_pctl;     by &byvar;     array trimvars{&xn} &vars;     array trimvarl{&xn} &varL;     array trimvarh{&xn} &varH;        do xi = 1 to dim(trimvars);            %if &type = winsor %then %do;             if not missing(trimvars{xi}) then do;               if (trimvars{xi} < trimvarl{xi}) then trimvars{xi} = trimvarl{xi};               if (trimvars{xi} > trimvarh{xi}) then trimvars{xi} = trimvarh{xi};             end;         %end;            %else %do;             if not missing(trimvars{xi}) then do;               if (trimvars{xi} < trimvarl{xi}) then delete;               if (trimvars{xi} > trimvarh{xi}) then delete;             end;         %end;        end;     drop &varL &varH xbyvar xi;     run;    %mend winsor;

Usage

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：delete del ele let Win values