data Have;
input Month $ Policy_Number $ IRDA_Amt OpsRefNo $10.;
datalines;
Nov-2020 XYZ 1000 20201005-M
Nov-2020 XYZ 500 20201015-A
Nov-2020 XYZ 100 20201222-A
;
run;
data have;
set have;
by Policy_Number;
if first.Policy_Number then n=0;
n+1;
run;
proc sql noprint nowarn;
select distinct catt('have(where=(n=',n,' ) rename=(IRDA_Amt=IRDA_Amt_',n,' OpsRefNo=OpsRefNo_',n,'))')
into : merge separated by ' '
from have
order by n;
quit;
data want;
merge &merge ;
by Policy_Number;
drop Month n;
run;
... View more