https://communities.sas.com/t5/SAS-Programming/proc-sql/m-p/282221#M57328 <P>How do you identify a "churner" or "non-churner"?&nbsp;What are the rules for the usage charge?&nbsp;Do you have dates? Are the Dates SAS date values or something else? Do you already have duration? "All the 6 months of 2011" is odd considering years usually have 12 months.</P> <P>You need to describe the data that you have.</P> Tue, 05 Jul 2016 17:24:15 GMT ballardw 2016-07-05T17:24:15Z https://communities.sas.com/t5/SAS-Programming/proc-sql/m-p/282215#M57326 hi, what should be the code ? Calculate the average Call duration ,count of local calls, and total usage charge for churners and non churners for all the 6 months i) for year 2011ii) for year 2010 and where average call duration is less than 60 seconds . using proc sql ? Tue, 05 Jul 2016 17:12:42 GMT https://communities.sas.com/t5/SAS-Programming/proc-sql/m-p/282215#M57326 Prateek1 2016-07-05T17:12:42Z https://communities.sas.com/t5/SAS-Programming/proc-sql/m-p/282221#M57328 <P>How do you identify a "churner" or "non-churner"?&nbsp;What are the rules for the usage charge?&nbsp;Do you have dates? Are the Dates SAS date values or something else? Do you already have duration? "All the 6 months of 2011" is odd considering years usually have 12 months.</P> <P>You need to describe the data that you have.</P> Tue, 05 Jul 2016 17:24:15 GMT https://communities.sas.com/t5/SAS-Programming/proc-sql/m-p/282221#M57328 ballardw 2016-07-05T17:24:15Z