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

Is there a way to write a data_Null step to include the variable names as headers, the variable output, that somehow makes it so that I get the desired output. I'm not seeing where the extra tabs and delimiter was added to this particular variable. It's a very simple program.    Thank you, JMagenta ... View more

Thank you much!   J ... View more

This kind of worked, only I am now missing some data somehow. I also have duplicates.   Thank you, J ... View more