/*Rename thevariables as stockcode, reportdate, name, reward, allowance, sharehold. Formatdata appropriately.*/

dataexExecutive1;

setExecutive ;

renameStkcd=stockcode Reptdt=reportdate D0101b_en=name D1001b=reward D1002b=allowanceD1101b=sharehold;

Stkcd_num=input(Stkcd,6.);

Rptdt_num=input(Reptdt,YYMMDD10.);

run;

procprint data=exExecutive1;

formatStkcd_num 6.;

formatRptdt_num mmddyy10.;

formatname $30.;

formatreward 10.;

formatallowance 5.;

formatsharehold  5.;

run;

procsql;

CreateTable EXECUTIVE2 as

     select

       Stkcd_num as stockcode, sum(reward)  assumreward, sum(allowance) as sumallowance,sum(sharehold)  assumsharehold,

      fromwork.exExecutive1 as a;

quit;