Thank you very much! This really helps! anand ... View more

Check only July, Aug and Oct in a calendar year? Not sure what mean here by missing September? If a student registers in July, August and October, I want to count that student only once in July and NOT in August and October. If there are no students at all registered in September, then i want September to show as zero students. Regarding your second question, YES - you are correct. My mistake - I manually was doing this so made a mistake. In this example, there should be zero students in August since they already are showing up in July. Thank you. ... View more

Thank you.   Below is the sample data table. id date 2186282 18JUL1995:13:21:29 2007173 19JUL1995:10:24:27 2007623 24JUL1995:11:20:27 2007173 10AUG1995:10:24:27 2007623 16AUG1995:11:59:52 2186282 25AUG1995:13:22:03 2117809 11OCT1995:13:31:30 2064119 26JUL1996:16:46:32 2064119 26JUL1996:16:46:40 2064119 19AUG1996:16:47:46 1220090 26AUG1996:00:00:00 2011790 27AUG1996:00:00:00 2011790 30AUG1996:00:00:00 2011790 03SEP1996:00:00:00 2008211 03SEP1996:10:36:43 2013623 04SEP1996:09:12:21 2013623 04SEP1996:09:12:24 2013623 04SEP1996:09:12:28 2013623 04SEP1996:09:12:32 2012087 05SEP1996:13:08:07 1259184 26SEP1996:00:00:00 2012342 01OCT1996:00:00:00 2064119 01OCT1996:16:50:51 1216288 02OCT1996:00:00:00 2008961 08OCT1996:11:25:31 2008961 08OCT1996:11:25:35 1220474 10OCT1996:00:00:00   The above table should have the values as shown the following table; date Unduplicated count cumulative count Jul-95 3 3 Aug-95 2 5 Sep-95 0 5 Oct-95 1 6 Jul-96 1 1 Aug-96 2 3 Sep-96 4 7 Oct-96 4 11   I will restate my problem.  First - I want to count each student only once in the month (first month) in a year. So if a student shows up in July and August and October of "One Year". I want to count that student only in July and not in August and October. Then, the next year, i want to do the same thing. Second - I want to have a column with a running total (cumulative total) for the months in a year. I want the cumulative totals  by year. So beginning of each year, the count starts from zero.    Thank you very much! ananda ... View more

Thank you for the quick response. Can you also give me the code if instead of student name, i have a numeric variable such as an id? Thanks. ... View more

Thank you to astounding. Your script worked too. i will keep yours too and study it as well.   Much appreciated! ... View more

Thank you to novinosrin and draycut. Your script worked. ... View more

Thank you draycut. What if there are values in hs column with just 0s and no 1s like below data have; input id term $ hs ; datalines; 123 200802 1 123 200901 1 123 201002 0 123 201003 0 123 201011 0 245 200401 1 245 200402 1 245 200403 1 245 201001 0 245 201002 0 321 200902 0 321 201001 0 321 201102 0 ; run; I need to keep the id with just the 0s as is. It should look like this data want; input id term $ hs ; datalines; 123 200802 1 123 200901 1 123 201002 0 245 200401 1 245 200402 1 245 200403 1 245 201001 0 321 200902 0 321 201001 0 321 201102 0 ; run; Thanks. Your other scripts work for the test run but when I run it against my full data set I get "variable hs is uninitialized", thoughts on that? Thanks ... View more

Thank you. Yes, it should look like how you have written. There are only two values in hs - 0 and 1. Thank you. ... View more

Thank you. I forgot to mention I have multiple ids. In other words, I want this condition by each unique id. I just gave an example for one unique id. Can you do for this table? Thanks. data test; input id term $ hs $; datalines; 123 200802 1 123 200901 1 123 201002 0 123 201003 0 123 201101 0 245 200401 1 245 200402 1 245 200403 1 245 201001 0 245 201002 0 ; run; ... View more

Thank you! Makes sense! ... View more

Thanks Fredrik. This code worked. I swear I did the same way yesterday and it did not work. I am guessing I may have something wrong.   I created my own code but seems more complicated. Below is my code;   data sgbstdn1a (drop=x); set sgbstdn; by sgbstdn_pidm; length fromdate todate $6; fromdate = first_term; x=lag(first_term); if first.sgbstdn_pidm then do; todate='999999'; end; else do; todate=x; end; run;     ... View more

Thanks Fredrik. Tried that, did not work as it still picks the terms from previous ids. ... View more