Hi i am having table numbers i am having 3 variables id1,id2,id3 i want to check the data if id1 and id2 and id3 repeating any where in the table having different clu should have the same clu number. data Numbers; infile cards dsd missover dlm="|"; input id1$ id2$ id3$ sas_id clu Run_date; format Run_date date9.; informat Run_date date9.; cards; a| | |1|1|24feb2012 |a| |2|2|24feb2012 | |a|3|3|24feb2012 b|b|b|4|4|24feb2012 e|e| |5|5|24feb2012 x|y|e|6|6|24feb2012 ; run; output a| | |1|1|24feb2012 |a| |2|1|24feb2012 | |a|3|1|24feb2012 b|b|b|4|4|24feb2012 e|e| |5|5|24feb2012 x|y|e|6|5|24feb2012 Based on the main table i want to create new table clu_change table SAS_ID|OLD_CLUSTER_ID|FROM_DATE|NEW_CLUSTER_ID|CHANGE_DATE clu_change Table 2|2|24feb2012|1|29feb2012 3|3|24feb2012|1|29feb2012 6|6|24feb2012|5|29feb2012 In this table it should give the sasid that are changing and from which cluster they are in past and what are now in presend and from date is the run_date of the main table and change_date is todays date.
... View more
