Thank you for your help. The city values are not consecutive numbers. It is just a value and may be any number. Does your code account for this or in that case I need another code to do this? Also, If there are more than two cities with the same ID, but different city values, does your code handle that too? ... View more

Thank you for your help. Would this code add all 'city' values to the IDs? I want the first ID associated with a city to be as it is and all other IDs that are associated with other cities (any number of cities) to have the city value to be added to the ID.  ... View more

Thank you for your comment. The reason I need to add the 'city' value to the 'ID' is that I need to have a unique ID in the data set because I after this step I will calculate the number of times an ID appeared, but since several cities used the same ID it makes the number of times an ID appeared incorrect. Each ID has other variables associated with as well. First I need to make sure that the IDs are not the same for different cities and then I will use PROC lifetest and PHREG. ... View more

@Rick_SAS, Thank you for your wonderful reply. Here is what I want in a SAS code form.   data Want; set km; by substructure_cond_060; if first.substructure_cond_060 then do; cumSum = Survival; end; for First step; (Suivival 1 + Survival 2)/2; output; for second step; (Survival 2+ survival 3)/2; output; for third step (Survival 3+ survival 4)/2; output; until the end. for last step (survival (n-1) +Survival (n))/2; output; I see that you summed Cumsum with survival which I dont want to do it. I just want to take the average of each step until the end for each group and output it to other column. Your input would be appreciated. Thanks, ... View more

@Tom, Thank you for your help. You have catched my point perfectly. Here is what I want.   data NBI_data; input Structure_Number_08 Substrucuture_condition Year_built datalines; 11700121 021 8 1910 11700121 021 8 1910 11700121 021 7 1910 11700121 021 7 1910 11700121 021 6 1910 2630 8 2012 2630 8 2012 2630 8 2012 2630 7 2012 2630 7 2012 . . . ; run; data_Nbi_Correlation; input Old_structure_Number_008 Strucutre_number_008; datalines 11700121 021 16349 . . . ; run; */The data I want shall have all values renamed with new values and also keep those already with new values.*/; Data want; input Structure_Number_08 Substrucuture_condition Year_built datalines; 16349 8 1910 16349 8 1910 16349 7 1910 16349 7 1910 16349 6 1910 2630 8 2012 2630 8 2012 2630 8 2012 2630 7 2012 2630 7 2012 I would be happy if you demonstrate the code based on my example. The value ( 11700121 021 ) is one value. ... View more

@Amirand @andreas_lds, thank you for asking more clarification. I want to replace only the Old_name and keep all the data relating to the name while changing it to the New_name. The SAS data set has Structure_Number_008 which is a mixture of Old_name and New_name such as the The Old_name is available in the excel file which correlates it to the New_name as below. I want to replace all Old_names in the SAS file if  the Old_name and its New_name is available in the excel file. I just want to replace the name and keep all the data related to the Old_name with the New_name. ... View more