Dear SAS community,   I am struggling to find the answer to something that may be a simple thing. Please help.   I have a macro variable:   %let variablenames = AAA BBB CCC DDD EEE FFF GGG;   If I want to find what position of  CCC which will show as 3. How can I achieve this?   Thank you for your help.   Regards,   T ... View more

Dear Community,   I am stuck. Please help! I am trying to label (count) without changing the sorting - by Condition. I need the year of appearance as the first, and label new condition differently.     Have:   ID   Condition Year   ID1  ZZ  2005 ID1  XX  2006 ID1  XX  2007 ID1  ZZ  2008 ID1  ZZ  2009 ID1  YY  2010   ID2  BB  2006 ID2  BB  2007  ID2  AA  2008 ID2  AA  2009 ID2  CC 2010     What I want:   ID   Condition Year  Want   ID1  ZZ  2005   1 ID1  XX  2006   2 ID1  XX  2007   2 ID1  ZZ  2008   1 ID1  ZZ  2009   1 ID1  YY  2010   3   ID2  BB  2006   1 ID2  BB  2007   1 ID2  AA  2008    2 ID2  AA  2009    2 ID2  CC 2010    3   Thank you!   Regards,   T   ... View more

Hello everyone,   I am trying to solve this problem but I haven't been able to. Please help.   %let thisvar = BUS; %let buslist = A B C D E;   %macro A; %do k = 1 %to %sysfunc(countw(&buslist)); %let list = %scan(&bustlist, &k) %let xlist = %sysfunc(cats(&list,1_,&thisvar));   ** I don't know how to do this part ***   %end; %mend; %A;   What I would like to have in the end is:   A1_BUS B1_BUS C1_BUS D1_BUS E1_BUS into some macro variable (say %let BUS=);   Please help. Thank you! ... View more

Dear SAS community,   Edit: My Apologies, I have amended the question.   This is yet another counting with the condition that I have been struggling with. Please help! Your help would be much appreciated. Suppose that I have data below;   Subject / Year / Condition   A 1991 1 A 1992 1 A 1993 2 A 1994 2 A 1995 3 A 1996 1 A 1997 1 B 1991 2 B 1992 1 B 1993 2 B 1994 1 B 1995 3 B 1996 1 B 1997 2       I cannot change the order of this, and I would like to start counting when "1" appears and continue counting without counting '2' or '3' so that I get   Subject / Year / Condition / Count   A 1991 1    1 A 1992 1    2 A 1993 2    2 A 1994 2    2 A 1995 3    2 A 1996 1    3 A 1997 1    4   B 1991 2    0 B 1992 1    1 B 1993 2    1 B 1994 1    2 B 1995 3    2  B 1996 1    3 B 1997 2    3   How can I achieve this?    Basically the end goal is to then find the number of each 1, 2, 3 and find the percentage of them to select which one I would choose based on the highest probability. But I will need to find a solution to this first. Thank you! Regards,   T ... View more

Dear SAS community,   I am having trouble counting and resetting the count with conditions and your help would be much appreciated. Suppose that I have data below;   Subject / Year / Condition   A 1991 2 A 1992 2 A 1993 1 A 1994 2 A 1995 2 B 1990 1 B 1991 2 B 1992 1 B 1993 2 C 1991 2 C 1992 2 C 1993 2 C 1994 2 C 1995 1   I cannot change the order of this, and I would like to start counting when first "1" appears and continue counting through "2" and reset each time "1" appears for the same individual. so that it would give me:   A 1991 2 0 A 1992 2 0 A 1993 1 1 A 1994 2 2 A 1995 2 3 B 1990 1 1 B 1991 2 2 B 1992 1 1 B 1993 2 2 C 1991 2 0 C 1992 2 0 C 1993 2 0 C 1994 2 0 C 1995 1 1   How can I achieve this? Please help. Thank you!   Regards,   T ... View more