I'm new to SAS macro programming. I did a lot research on this topic, but I still can't figure out how to integrate those good examples into my problem here. Problem: I have 2 SAS tables to work with, table A and table B. table A has a 6 month records. What I need to do is to extract distinct id weekly from this 6 months period. Each iteration, I need to perform this procedure as shown below: proc sql; select distinct id from table A where date >= '27SEP2013'd and date <= '03OCT2013'd; /* first week of the 6 months period*/ quit; proc sql; select count(*) as CNT, calculated CNT / (select count(distinct id) from table A) as response_rate from table A as A, table B as B where A.id = B.id quit; so I need to do this week by week for about 26 weeks to cover that 6 months period in Table A. I don't know how to use the %Do start_date %To end_date %By(week) loop to do this iteration. Any help? Thanks.
... View more