Data	work.CLKSuccessfuldata;
set CARTEL.pre_ivr_call_arrival;

Keep EVENT_DT PROGRAMME_NM NATIONAL_NUM PRE_IVR_QUEUE_DESC SUCCESS_CONTACT_CNT BUSY_CONTACT_CNT;

Where EVENT_DT>='01Jul2015'd
	and PROGRAMME_NM = '1.1 Social Security & Welfare';
	
Run;

Proc Sort Data=work.CLKSuccessfuldata;
By EVENT_DT PROGRAMME_NM NATIONAL_NUM PRE_IVR_QUEUE_DESC;
Run;	



Proc summary data=work.CLKSuccessfuldata sum noprint;

by EVENT_DT PROGRAMME_NM NATIONAL_NUM PRE_IVR_QUEUE_DESC;
VAR SUCCESS_CONTACT_CNT BUSY_CONTACT_CNT;

Output out=work.CLKSuccessfulSummarybyDay (drop=_FREQ_ _TYPE_) Sum=;

Run;


proc export   data=work.CLKSuccessfulSummarybyDay
			outfile='R:\NAT\SMARTCENT\SMCTRCHOP\GCFTELE\Telephony Performance\Successful_Data\CLK.xlsx'
			dbms = xlsx
			replace;
	
	

run;