Hi sas experts,   I am looking for a solution that starts from a dummy variable and counts the number of changes from value 0 to 1 during a pre-defined time window (in my case: 6 months) for each subject (id column).  The below example shows how the data that I have looks like, (including the col_have) and the outcome column that I want (col_want):   data data; input id time date9. col_have col_want; format time date9.; datalines; 1 01DEC2012 1 2 1 01NOV2012 0 1 1 01OCT2012 1 2 1 01SEP2012 0 1 1 01AUG2012 1 1 1 01JUL2012 1 1 1 01JUN2012 1 2 1 01MAY2012 0 1 1 01APR2012 0 1 1 01MAR2012 1 1 1 01FEB2012 1 1 1 01JAN2012 0 0 2 01DEC2013 0 0 2 01NOV2013 0 0 2 01OCT2013 0 1 2 01SEP2013 0 1 2 01AUG2013 0 1 2 01JUL2013 0 2 2 01JUN2013 1 2 2 01MAY2013 0 1 2 01APR2013 1 1 2 01MAR2013 1 1 2 01FEB2013 0 0 2 01JAN2013 1 0 ; run;   To give a bit of details, the algo should take each date and count the number of times for which the col_have changes values from 0 to 1 during the last 6 months.   Thank you very much in advance for effort and support! ... View more

Hi,   I have a table from which I want to store in a macro variable all columns that contain a specific value. For example:   data have; input abc def ghi jkl 8.; datalines; 1 4 2 3 6 99 0 8 3 99 6 5 2 4 0 99 ; run;   Here I would like to obtain all columns which contain the value 99: def, jkl. ... View more