Hi SAS Experts Normally I would have one line per patient per admission however in this case it is to complicated and instead I have multiples lines per patient per admission. I my normal case I would use an array  and then define my diagnosis variables (please see example code below).   data indlagte_main; set indlagte_main; addiction=0; alcohol=0; array x{*} diagindH1-diagindH2 diagindB1-diagindB10; do i=1 to dim(x); if substr(misdiag{i},1,3) in ('DF1') then do;addiction=1; end; if substr(misdiag{i},1,4) in ('DF10') then do; alcohol=1; end; end; run;   This is what I have now   Record_id admissionnumber Admission date Discharge date date of diagnosis diagnosis 1 1 01-01-2010 01-02-2010 02-01-2010 df200 1 1 01-01-2010 01-02-2010 02-03-2010 df100 1 2 03-03-2010 31-03-2010 04-03-2010 df147 1 2 03-03-2010 31-03-2010 04-03-2010 df200   This is what I want. Addiction and alcohol definitions should be the same as in the above array.   Record_id admissionnumber Admission date Discharge date Addiction Alcohol 1 1 01-01-2010 01-02-2010 1 1 1 2 03-03-2010 31-03-2010 1 0   I hope this makes sence.   Kind regards from   Solvej ... View more

Dear SAS Experts   I have what I think is a simple problem that I hope you can help me with.   I have the following data and would like to exclude line number 3 and keep number 2. Please notice that it is the date of diagnosis that are of interest and in both cases these are after admission but in line 3 it is after admission and within the time frame of the 2 admission.     Record_id admission_number Admission date Discharge date date of diagnosis diagnosis       1 1 01-01-2010 01-02-2010 02-01-2010 df200       1 1 01-01-2010 01-02-2010 02-03-2010 df100 I want to keep this line 1 1 01-01-2010 01-02-2010 04-03-2010 df147 I want to exclude this line 1 2 03-03-2010 31-03-2010 04-03-2010 df147       1 2 03-03-2010 31-03-2010 04-03-2010 df200       2                 2                 2                 2                   Kind regards   Solvej ... View more

Hi SAS Experts   I would like to group a variable that contains a wide range of "text". I have the grouping of the variables in another dataset where the different versions of the text that needs to be grouped together is listed in different variables. How can I do this?    I'm using Base SAS 9.4   This is an example of the data I have and that I would like to recode. I the real world there are 1000s of lines.   n text Column i would like 1 ab 1 2 abc 1 3 ad 2 4 abc 1 5 hi 3   This is an example of the other dataset that I have which should define the recoding. 1 2 3 ab ad hi abc       I hope you can help.   Solvej ... View more