in my data, the gender has values like Male, M, m, male, Female, FEMALE, F, f. When i use proc freq, they are all listed as different values. I can recode them using if condition, but is there a simpler way to recode them unifomly?   Thanks ... View more

I have 7 data sets which have the same data structures (ID, age, Gender, etc). I want to combine them and then remove the duplicates. There is about 40% duplicated IDs. Some variables (like age or gender have a few missing values)   one way is to use set operation, and concatenate them into a file, and then use proc sort and nodupkey to remove the duplicate IDs. In this way, there is a chance that I removed obs with age and gender info but kept those with missing values in age or gender.   is there a way that I can combine them, during which the missing values in age or gender can be replaced by available values when ID is the same?   Thanks ... View more

In my data set, the variable limit_set_period has both values of "Day" and "Daily". I want to change the "Day" values to "Daily" by   replace limit_set_period = "Daily" if limit_set_period = "Day"; but it does not work   any hints? Thanks ... View more