Hello dear SAS community.   I have the following question, there are two variables (id1 and id2) in a table (see below), which should be compared with each other.   Is it possible to delete the matching observations from this table (position of the observation does not matter), so that only the unique observations for these two variables remain there?     id1 id2 990000 990000 990002 990000contour 990003 990002 990006 990003 990007 990006 990008 990007 990016 990008 990018 990016 990021 990018 990024 990021   I would be delighted to receive an answer. ... View more

Dear SAS community, I would like to ask you to help me solve the following problem.   I have the following data set: Id Subid T1 Tx Both 1   1           1   0   (1) 1   2          1   0   (1) 1   3          0  1    (1) 1   4          0  1    (1) 2   1          0  1    (0) 2   2         0  1    (0) 2   3         0  1    (0)   There are some Id's with subid's listed. At the same time, these have 2 dummy variables "T1" and "Tx", which never have the same value. This means that if T1=0, then Tx=1 and vice versa.   The question is: how can I create a variable "Both" that checks whether both dummies within a single Id have a value of 1?   Like if T1=1 and Tx=1 wihtin Id=1 then Both=1   Many thanks in advance. ... View more

Dear SAS Community,   I need your help. I have the following data set:   file          name          var file1                           0 file2        name1        1 file3        name1        1 file3        name2        1 file4                           0 file4        name1        1   The currently question is - how can I check that the entries of variable "name" are always numbered, i.e. always "name1, name2", etc. And not for example "name1, name3" or "name1, name2, name4".   And if there is a wrong order, how can I convert them beeing numbered correctly.   Thank you in advance. ... View more