Not the Optimal way of doing this but see if this works for you. data have;
input Client_name $ Cost_of_service service_month;
cards;
bobby 15 1
bobby 15 1
bobby 24 1
bobby 10 2
bobby 11 2
bobby 5 2
james 20 1
james 21 1
;
run;
Proc summary data=have nway;
var Cost_of_service;
class Client_name service_month;
output out= temp(drop=_freq_ _type_) sum= ;
run;
proc transpose data=temp out=temp_out(drop=_name_ rename=("1"n=Jul_Cost_ "2"n=Aug_Cost_));
var Cost_of_service;
id service_month;
by Client_name ;
run;
data want;
merge have temp_out;
by Client_name;
run;
... View more