Sorry,   ID is a unique Identifier. DC date is the same because all codes happened on the same date Think of Direction as a person's last name so it would be the same but unique to that person, as ID is unique to that person. What I really want to make sure of is that even if someone has the same last name they won't have the same ID since ID is unique and not names. If in the group of the person's ID's there is a unique ICode then I want to capture it. Otherwise I don't wan it.     ... View more

ICode1 and ICode2, represent ICode to the nth in the original dataset. I could drop the new ICODE in the new dataset I guess. In reality, I have up to ICode10 with not all of them being filled. I really just want for the group of IDs to capture only the unique ICode values.   ... View more

Sorry,   I would like the following output ID  DCDate Direction  ICode1 Icode2 1 2 South Q22.x Q22.y 1 2 South Q23.x   2 2 South Q22.x Q22.y 2 2 South Q23.x     Keeping only the unique ICODEs for each ID group.                 ... View more

To Everyone on this project!!   THANK YOU!!! I am learning day by day, and you are each helping me do that!   JMagenta ... View more

data work.have; array Apples {20} 8; array Carrots {20} 8; array Oranges {20} 8; do i=1 to dim(apples); apples[i]=i+1; /* I did "i+5" and so forth so that the numbers were unique values*/ carrots[i]=i+5; oranges[i]=i+8; end; drop i; run; proc sql noprint; select name into :varlist separated by ' ' from dictionary.columns where libname='WORK' and memname='HAVE' and ( upcase(name) like 'APPLES%' or upcase(name) like 'CARROTS%' or upcase(name) like 'ORANGES%' ) order by compress(name,,'kd'), name ; quit; data have2; retain &varlist; set have; Array Apples_ {*} apples1-apples20; Array Carrot_{*} Carrots1-carrots20; Array oranges_{*} oranges1-oranges20; do i=1 to dim(apples_); Earlyfruit=min(of apples_[*]); Afruit=Carrot_[min(of apples_[*])]; Bfruit=Oranges_{min(of apples_[*])}; end; run; The result value for Easyfruit is correct and equals Apples1 which is 2. The result for Afruit should equal Carrots1 which is 6 instead it equals 7 (likely the value of Apples6). The result for Bfruit should equal Oranges 1 which is 9 instead it equals 10 (likely the value of Apples9).     ... View more

Hello, I get it, but to be clear,   This was the only way I could find to group the data.  Each variable group: Apples1 Oranges 1 Carrots1 belongs to basket1.    Apples2 Oranges2 Carrots2 belongs to basket2 and so on.   So if Apples2 is the variable with the minimum value for that line for Basket1; Then basically what is Carrots2 and Oranges2: FruitA=Oranges2; FruitB=Carrots2;   This is what I want.   Sorry if it's not too clear. ... View more

Awesome! Thank you so much! But for the last part, where I create new variables, it gets tricky.  Could this work?     data have2; retain &varlist; set have; Array Apples_ {*} apples1-apples20; Array Carrot_{*} Carrots1-carrots20; Array oranges_{*} oranges1-oranges20; do i=1 to dim(apples_); Earlyfruit=min(of apples_[*]); Afruit=Carrot_[min(of apples_[*])];   /* I want the carrot that is chosen to match the suffix of Apple without changing the value of Carrot*/ Bfruit=Oranges_[min(of apples_[*])]; /* same here with Oranges*/ end; run; ... View more

Thanks you,   I will add one caveat, there is a parsing where statement that describes what the first occurrence should equal. It also includes a like statement. So I tried this:   data have ; input ID Name $ Status $10. ; cards; 1 David Cool 1 David Cool 1 David Not Cool 2 Sam Warm ; data want; set have ; by id; length NEW $30 ; Where upcase(Status) like '&Cool&'; if first.id then do; NEW = 'Cool Person'; else do NEW = 'Other statuses' ; end; else NEW = 'Other Status for this person' ; run; But it didn't work. ... View more

Hello,   I have a  data set, SAMPLE, here:   ID Name Status 1 David Cool 1 David Cool 1  David Not Cool 2  Sam Warm       For each group I want to select the first occurrence of STATUS where the value is "Cool"  and set my new variable Bingo as "Cool Person".  I want categorize  duplicate values of  "Cool" for the variable STATUS,  as well as other values of STATUS  in the group with the variable, Bingo, as  "Other Statuses for this person".  I want to also categorize other groups without the value of "Cool"  for STATUS as "Other Statuses" for BINGO.  If possible I would like one data step or proc sql step for this.  I know I need to sort the data too.    I want the data to look something like this   ID Name Status Bingo       1 David Cool Cool Person 1 David Cool Other Status for this person 1  David Not Cool Other Status for this person 2  Sam Warm Other Statuses     How can achieve this? Any help with this is welcome and much appreciated!   Thank you, J Add Tags 0 Likes     Quick Reply ... View more

Sorry for the confusion. I needed a solution not a troll. Thank you though. ... View more

My mistake, I was not using it correctly. This worked!   JMagenta ... View more

This option did not work.   Thank you. ... View more