A variable is to be created that contains unique values like 00001,00002 etc.
Now if all the unique values are assigned during execution, the value should not repeat when the code executes during next week execution. It should repeat only for cases where the key variable like member is same else it should assign different value from all previously assigned values. So how can we monitor all previously assigned values and if the member is same we assign same value else we assign different value for all future executions
data First_Execution; input memberid 8.; datalines; 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 ;
data First_Execution_1; set First_Execution; FORMAT Source_ID $13.; Source_ID= cats("777",put(_N_,z7.)) ; run;
data Next_Execution; input memberid 8.; datalines; 1001 1002 1012 1004 1005 1011 1013 1015 1009 1015 ;
data Next_Execution_1; set Next_Execution; FORMAT Source_ID $13.; Source_ID= cats("777",put(_N_,z7.)) ; run;
During next execution if the member is present in the previous execution source ID will be same, else it will be different. So how should we create a base of all previous executions and store this information.
... View more