Hi,    I'm working with a dataset that looks similar to the following:   Construction_date     Material 1991                           Cement 1972                           Wood 1991                           Cement 1991                           2002                           Wood 1983                           Wood 1991                           Wood   I would like to impute missing material data through the following condition:   if there are more than one identical construction_date and the material from at least two of those dates match, then make it so that all other identical missing construction_date have the same material.   From the little I know, I would first have to sort my construction_date and material variables, and then I get lost from that point on.   proc sort data=data; by construction_date material; run;   Note that I am a very new to coding language, and this is a large dataset.   Would appreciate any and all help! ... View more

Hi,   I’m trying to determine the race of subjects in my dataset based on their last name. I have a list of last names that indicate a given race. My dataset looks something like this:   White_name               Subject_name             Race Johnson                      Appleby                      White MacDonald                 Brians                         White Burns                          MacDonald                 [blank] Manning                     Murphy                        White   White_name represents a databank of all potential white last names. Subject_name represents the last name of the subjects in my sample. Race is a partially complete variable with information on their race.   I would like to fill in the blanks in the Race variable based on the Subject_name being found in the White_name list.   My logic would flow something like this: if subject_name=any of the White_name then race2=’White’; else race2=race;   However, I believe I need to loop through all the names in the White_name variable in order to find a match. Note that I have a large cohort with many repetitions of last names.   Would appreciate any help! Please note that I am a very new SAS user!   Thank you! ... View more