Hello, I'd like to compute the relative frequency based on a binary variable (case) in the following way. For each record within each id, I'd like to measure the rate for records that are within 1 year prior to that record (including the record itself). Here's a summary of codes for the have/want data files. I'd appreciate the forum for any idea! data have; INFORMAT date MMDDYY10.; input id date case; FORMAT date MMDDYY10.; datalines; 1 1/15/2008 1 1 1/31/2009 0 1 4/13/2009 0 1 5/30/2009 1 1 1/7/2010 1 2 1/24/2008 0 2 2/19/2009 1 2 4/21/2009 1 2 5/12/2009 0 2 7/11/2010 1 ; data want; INFORMAT date MMDDYY10.; input id date case rate ; FORMAT date MMDDYY10.; datalines; 1 1/15/2008 1 1 1 1/31/2009 0 0 1 4/13/2009 0 0 1 5/30/2009 1 0.33 /* example: 0.33 = 1/3 */ 1 1/7/2010 1 0.50 /* example: 0.50 = 2/4 */ 2 1/24/2008 0 0 2 2/19/2009 1 1 2 4/21/2009 1 1 2 5/12/2009 0 0.67 2 7/11/2010 1 1 ;   ... View more

I have two dates (start and stop), and I'm trying to create one column for each date between these two dates. Below is the summary of a macro I'm using. However, I'm getting this error: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. I was wondering if anyone could help me with this error. Thanks in advance! data have; INFORMAT date_start date_stop MMDDYY10.; input date_start date_stop ; FORMAT date_start date_stop MMDDYY10.; datalines; 1/15/2008 1/16/2008 1/28/2008 1/30/2008 2/12/2008 2/16/2008 ; data want; INFORMAT date_start date_stop date_1 date_2 date_3 date_4 date_5 MMDDYY10.; input date_start date_stop date_1 date_2 date_3 date_4 date_5; FORMAT date_start date_stop date_1 date_2 date_3 date_4 date_5 MMDDYY10.; datalines; 1/15/2008 1/16/2008 1/15/2008 1/16/2008 1/28/2008 1/30/2008 1/28/2008 1/29/2008 1/30/2008 2/12/2008 2/16/2008 2/12/2008 2/13/2008 2/14/2008 2/15/2008 2/16/2008 ; /* SAS macro code */ %macro test; data want; set have; %do i = 1 %to date_stop - date_start + 1; format date&i MMDDYY10.; date&i = intnx('day', date_start, i); %end; run; %mend; %test ... View more