Suppose I have a dataset: --Have-- KIND KIND_CD var1 var2... A 1 1 A . 2 A 1 3 . 1 4 . 1 5  All observations belongs to same KIND, but for some reason some values are missing. The dataset I want is:   --want-- KIND KIND_CD var1 var2... A 1 1 A 1 2 A 1 3 A 1 4 A 1 5 I tried to create KIND_1 and KIND_CD_1 to retain the non-missing value. But since I have lots of 'KIND' variables, this may not be a good method.   ... View more

Suppose I have a dataset:   --Table 1-- ID Amount A 0.1 A 0.2 A 0.3 B 0.4 B 0.5 I used retain to create a new variable of total amount of each ID : data sample; set sample; by ID amout; if first.ID then Total_amount = 0; Total_amount = Total_amount +amount; run; And this will be the output dataset: --Table 2-- ID Amount Total_amount A 0.1 0.1 A 0.2 0.3 A 0.3 0.6 B 0.4 0.4 B 0.5 0.9 But now I want to assign the true total_amout to each obs. The output I want is:   --Table 2-- ID Amount Total_amount A 0.1 0.6 A 0.2 0.6 A 0.3 0.6 B 0.4 0.9 B 0.5 0.9  Is there anyway to achieve it? Now I try to sort the data in descending order and than retain the total_amount. data sample; set sample; by ID descending amout; if first.ID then Total_amount_1 = Total_amount; run;   --Table 2-- ID Amount Total_amount Total_amount_1 A 0.3 0.6 0.6 A 0.2 0.3 0.6 A 0.1 0.1 0.6 B 0.5 0.9 0.9 B 0.4 0.4         0.9  Although I can get what I want by this way, I think this method is kind of stupid. I hope there are some better methods. ... View more