i would like to get the result found below if the input was the table below, attached is an excel sheet for easier access to the data Input Example       ID Card Usage Limit 123 1111 50 100 123 1112 10 20 123 1113 15 50 456 2221 40 50 456 2222 0 10   Output Required                 ID Card1 Usage1 Limit1 Card2 Usage2 Limit2 Card3 Usage3 Limit3 123 1111 50 100 1112 10 20 1113 15 50 456 2221 40 50 2222 0 10 0 0 0 ... View more

there is a nested IF Statement i apply in excel, and i want to know how I do it in SAS Programming, i am sure it is doable, i am just not sure how to do it.  ex:  i have a table containing the below data ID                     Color  123                   Blue 123                   Yellow 123                   Green 345                   Pink 345                   Red 345                   Blue 345                   White   the result i want is:  ID                     Color  123                   Blue, Yellow, Green 123                   Blue, Yellow, Green 123                   Blue, Yellow, Green 345                   Pink, Red, Blue, White 345                   Pink, Red, Blue, White 345                   Pink, Red, Blue, White 345                   Pink, Red, Blue, White     the IF Statements i use for the first option (where there is 3 duplicated ID number, for the 9th row) is:  =IF((A9=A8)*AND(A9=A7),G7&"," G8&","&G9,(IF((A9=A8)*AND(A9=A10),G8&"," &G9&","G10,(IF((A9=A10)*AND(A9=A11),G9&G10&G11))))   the IF Statements i use for the second option (where there is 4 duplicated ID number, for the 16th row) is:  =IF((A16=A15)*AND(A16=A14)*AND(A13=A16),G13&","&G14&","&G15&","&G16,(IF((A16=A14)*AND(A16=A15)*AND(A16=A17),G14&","&G15&","&G16&","&G17,(IF((A16=A15)*AND(A16=A17)*AND(A16=A18),G15&","&G16&","&G17&","&G18,(IF((A16=A17)*AND(A16=A18)*AND(A16=A19),G16&","&G17&","&G18&","&G19)))))))   how do i get the same result using SAS Programming?  ... View more