Is there a function in SAS to that converts "Sunday" = 1, "Monday" = 2, etc. or should I just write the codes to do it?   ... View more

I have a SAS Datasets with multiple equalities: i.e. A=C, B=C etc. and I would like to make concatenate it into one line to A=B=C.   For example, IDs in 1 and 2 represent equality in the following dataset: ID1, ID2; 1,3; 2,3; 1,4;   I would like to convert this into:   ID1, ID2, ID3 ID4; 1, 2, 3, 4;   Would there be a good algorithm to do this? ... View more

I have a SAS Datasets with multiple equalities: i.e. A=C, B=C etc. and I would like to make concatenate it into one line to A=B=C.   For example IDs in 1 and 2 represent equality,   ID1, ID2;   1,3; 2,3;   I would like to make these into    ID1, ID2, ID3; 1, 2, 3;   Would there be a good algorithm to do this?     ... View more