Hi ksharp, Hitting some errors as well, if the headers and observations are more complicated as in my 2nd post. Would appreciate your advice as well. My apologies for not noticing all the patterns of the data. ... View more

Hi Art, Thanks for the reply. Tried the code suggested. I'm hitting some syntax errors. I think because my actual data is more complicated than what i had posted originally. 1) some of the headers consist of two words, and some have special characters. 2) some of the data(non header) has alphabets. I hit syntax errors for observations that hit above 2 scenarios. ABC XYZ 04885423 04886522T 0488G09876 4666324557677879 DEF 4321234567897654 5434456434565211 GHI #CVD 0466643 089876665 0987643349 ABC 097457738 73638933 03988833 Would really appreciate your advice. ... View more

Hi everyone.... Thank you for all the help.... Proc tabulate solved the problem. Thanks again! Now, i need to do more than a simple count. Data will be the same format as before. Here's what i need to do : only count the record as 1 if the current and previous call gap>=30 mins Name. Cardno. Datetime. Count Victor. 12345. 9/8/2010 8:04:28 AM. 1 Victor. 12345. 9/8/2010 8:09:42 AM 0 Victor. 12345. 9/8/2010 8:11:17 AM. 0 Victor. 12345. 9/8/2010 8:12:13 AM. 0 Victor. 12345. 9/8/2010 9:11:12 AM. 1 Victor. 12345. 9/8/2010 4:05:57 AM. 1 Explanation: 1st observation is counted as it is the first call. 2nd, 3rd, 4th obs not counted as they are all within 30 mins of first call. Obs 5 is counted as it exceeds 30 mins when compared to 1st obs. Obs6 also counted as it exceeds 30 mins when compared to obs 5. Again i need to know how many times EACH customer calls and how many times they call PER MONTH but with the new condition. Need all the help i can get. Thanks. Message was edited by: Zoey Elle ... View more

Hi Ksharp and yonib; Will try out the suggestions. Thank you very much! ... View more