Hello everyone,   With the help of instructions (http://support.sas.com/kb/40/338.html) I made a query to get a list with only duplicate values of a column. I put a filter on another column to only select those values that are greater than 0.   When I run it, the filter does not work. I do get values of 0...   What could I be doing wrong?   Thanks in advance! ... View more

Hello everyone,   Can someone help me with the following: I have two colums. Sometimes the value in one of them is missing. The values form unique pairs. For example: when G is in the first column, then D should be in the second. G and D can only match with eachother. (note that D can never be in column 1 and G never in column 2). I would like SAS to fill the missing spots with the right value, that becomes clear from the rows that do have a matching value in the other column.   I would like to go from this: Column 1         Column 2 A                        B .                         J G                       D F                        . .                         C F                        J O                       C O                       C A                        . A                        . .                         D .                         D .                         B   (you can see that the pairs are: A&B, G&D, F&J and O&C)   To this: Column 1         Column 2 A                         B F                         J G                        D F                         J O                        C F                         J O                        C O                        C A                         B A                         B G                         D G                         D A                         B   Many thanks in advance! ... View more