year id censor 2001 1 1 2002 1 1 2003 1 1 2004 1 1 2005 1 1 2006 1 1 2002 2 0 2003 2 0 2004 2 0 2005 2 0 2006 2 0 2002 3 0 2003 3 0 2004 3 0 2005 3 0 2002 4 1 2003 4 1 2004 4 1       From this table, to make a table below,   year id censor y01 y02 y03 y04 y05 y06 outcome 2001 1 1 1 0 0 0 0 0 0 2002 1 1 0 1 0 0 0 0 0 2003 1 1 0 0 1 0 0 0 0 2004 1 1 0 0 0 1 0 0 0 2005 1 1 0 0 0 0 1 0 0 2006 1 1 0 0 0 0 0 1 0 2002 2 0 0 1 0 0 0 0 0 2003 2 0 0 0 1 0 0 0 0 2004 2 0 0 0 0 1 0 0 0 2005 2 0 0 0 0 0 1 0 0 2006 2 0 0 0 0 0 0 1 1 2002 3 0 0 1 0 0 0 0 0 2003 3 0 0 0 1 0 0 0 0 2004 3 0 0 0 0 1 0 0 0 2005 3 0 0 0 0 0 1 0 1 2002 4 1 0 1 0 0 0 0 0 2003 4 1 0 0 1 0 0 0 0 2004 4 1 0 0 0 1 0 0 0   I tried to use array function, but it didn't work out well.   Could you please help me to make a code for this?   Thanks so much.   ... View more

From the table below, if I want to make a variable that shows at least "1" in v1 as the same value,     year id v1 1 1 0 2 1 0 3 1 0 1 2 0 2 2 0 3 2 1 1 3 0 2 3 1 1 4 0 2 4 0 3 4 0   looks like this   year id v1 v2 1 1 0 0 2 1 0 0 3 1 0 0 1 2 0 1 2 2 0 1 3 2 1 1 1 3 0 1 2 3 1 1 1 4 0 0 2 4 0 0 3 4 0 0   How can I simply make a code? Last time, I used first and last function, but it made too many datasets.  I think coalesce in proc sql can do something, but I don't know how to do it... Could you please help me? ... View more

In a longitudinal data, the frequency can be calculated by proc freq, but what if I want to know whether a subject has a particular response or not over the time in a long format. I think it will be necessary to have a summarized table.  For example, I have a long format data like below.   time id v1 1 1 no 2 1 no 3 1 yes 4 1 yes 1 2 no 2 2 no 3 2 no 4 2 no 1 3 yes 2 3 no 3 3 no 4 3 no  from this table, I want to know how many subjects (id) have at least one response (yes) for v1 over time.  In this case v1 is shown in id 1 and id 3 so that will be 2. Is it necessary to have a table like below to obtain the results? If it's the case, could you please let me know the programming code? Thanks.   id total_v1 v1_freq 1 yes 2 2 no 0 3 yes 1 ... View more

year month date id v1 v2 2001 1 1 1 1 0 2001 1 2 2 0 1 2001 1 12 2 0 1 2001 2 13 2 1 1 2002 2 14 3 1 0 2002 3 1 3 0 1 2002 5 12 3 1 1 2003 2 13 2 0 1 2003 4 14 2 0 1 2003 5 1 2 1 1 2003 5 12 3 1 0 2003 7 13 3 0 1 2003 8 14 3 0 1 2003 9 1 3 1 1 2003 10 1 3 1 0 2003 11 13 3 0 1 2003 12 25 3 0 1   From this data, I want to make a different table by summing frequencies from each variable by year and moth. The expected result will be like this. year month v1_freq v2_freq 2001 1 1 2 2001 2 2 1 2001 3 0 0 2001 4 0 0 2001 5 0 0 2001 6 0 0 2001 7 0 0 2001 8 0 0 2001 9 0 0 2001 10 0 0 2001 11 0 0 2001 12 0 0 2002 1 0 0 2002 2 1 0 2002 3 0 1 2002 4 0 0 2002 5 1 1 2002 6 0 0 2002 7 0 0 2002 8 0 0 2002 9 0 0 2002 10 0 0 2002 11 0 0 2002 12 0 0 2003 1 0 0 2003 2 0 1 2003 3 0 0 2003 4 0 1 2003 5 2 1 2003 6 0 0 2003 7 0 1 2003 8 0 1 2003 9 1 1 2003 10 1 0 2003 11 0 1 2003 12 0 1   What codes can I use?  Thank you so much in advance! ... View more

I wonder what is the general rule for extracting eligible subjects in a counting process format in SAS. For example, take a look at the table below. Let's assume that I set a condition that a subject (ID) is not eligible if psyc_c is both 0 during 2002 and 2003. Then I wouldn't want to include the subject in the dataset. I think that I deal with a problem like this very often in programming in a counting process format. Another example can be that I want to eliminate subjects if there is a certain number in a variable in a certain year. For example, I want to eliminate a subject if their psyc_c is 3 in 2004, then ID 3 will be excluded from the data. Please help me to figure out.. Thanks..    Year Id psyc_c dprs_c 2002 1 0 0 2003 1 0 1 2004 1 0 0 2005 1 0 0 2006 1 0 0 2002 2 0 0 2003 2 0 0 2004 2 0 0 2005 2 0 0 2006 2 0 0 2002 3 0 2 2003 3 0 0 2004 3 3 0 2005 3 0 0 2006 3 0 0 2002 4 1 0 2003 4 0 0 2004 4 0 0 2005 4 0 3 2006 4 0 3 ... View more