I have a dataset with one variable in a really messy format. I'd like to keep the rows with this variable value containing a list of words in both lower or upper case. There are around 20 words for this list. My question is like this post: https://communities.sas.com/t5/SAS-Procedures/Search-in-a-dataset-for-units-only-containing-words-in-a-list/m-p/842613#M82208 But my word list is longer and I'd like to ignore the influence of lower or upper case.  How should I write the SAS code? Thank you. this is my code, but after running it, I get 0 observations.   %let med_list = a b c d ...; data data_filter; set data; if find(RAW_NAME,"&med_list", 'i') > 0; run;   Additionally, I also would like to change the RAW_Name to the matched word in med_list. How can I do it? ... View more

This is my code, but I just realized the result I have are all missing values.   I wonder how can I get the median survival time?   proc lifetest data=survival method=km; time survival_time * event(0); strata race; run;   ... View more

How can I choose the earliest date from a list of variables, and create a new variable save the earliest date. The missing values are saved as "." for these 5 variables.  The missing values should be ignored when comparing. Only if 5 date variables are  all missing, the new variable will be saved as a missing value.    The code I wrote: data df1; set df; earliest=min(of date_a date_b date_c date_d date_e); format earliest mmddyy10.; run;    The new variable was created, but all the values are missing.  ... View more