Dear experts   I have two datasets - one with admission and a second one with treatments. I would like to know whether a specific patient have been treated with in the last two years. A patient can have multiple treatments and admissions.   The datasets look like have1 and have 2 (see below). Want is what I would like to see with an indicator variable showing whether this specific patient at this specific admission have been treated within the last two years.   I hope it makes sense.   Thanks a lot.   Kind regards Solvej   data have1;   input Record_id admission_number (Admission_date Discharge_date ) (:ddmmyy10.)   ; format Admission_date Discharge_date ddmmyyd10.; datalines;   1 1 01-01-2010 01-02-2010 1 2 03-03-2010 31-03-2010 1 3 03-03-2011 31-03-2011 2 1 01-01-2010 01-02-2010 2 2 01-01-2011 01-02-2011 2 3 03-03-2013 31-03-2013 2 4 03-03-2018 31-03-2018 3 2 03-03-2010 31-03-2010 3 2 03-03-2015 31-03-2015 4 2 04-02-2011 04-03-2011 ; run;   　 data have2;   input Record_id treat_number (treatin_date treatout_date) (:ddmmyy10.)   ; format treatin_date treatout_date ddmmyyd10.; datalines;   1 1 01-01-2007 01-02-2007 1 2 03-02-2010 28-02-2010 1 3 03-03-2017 31-03-2017 2 1 01-01-2006 01-02-2006 2 2 01-01-2008 01-03-2008 2 3 03-03-2017 31-03-2017 3 1 03-03-2017 31-03-2017 4 1 03-03-2010 31-03-2010 4 2 04-02-2012 04-03-2012 ; run;   　 　 data want;   input Record_id admission_number (Admission_date Discharge_date ) (:ddmmyy10.)   treated_2years_prior; format Admission_date Discharge_date ddmmyyd10.; datalines;   1 1 01-01-2010 01-02-2010 0 1 2 03-03-2010 31-03-2010 1 1 3 03-03-2011 31-03-2011 1 2 1 01-01-2010 01-02-2010 1 2 2 01-01-2011 01-02-2011 0 2 3 03-03-2013 31-03-2013 0 2 4 03-03-2018 31-03-2018 1 3 2 03-03-2010 31-03-2010 0 3 2 03-03-2015 31-03-2015 0 4 2 04-02-2011 04-03-2011 1 ; run;   ... View more

Hello   How can in read in the following text file easily.       The text files are structured the following way. afd1301033             200001011999112425000101Hjertemedicinsk klinik B, kardiologisk laboratorium    I'm only interesseret in part of the lines marked by bold. I have tousands of linies.    Kind regards   Solvej ... View more

Dear SAS experts   I have a dataset x1 and dataset x2. I would like for specific variables of x1 to take the value of other variables in x2 under specific conditions.   This is my suggestion for programming. I hope this makes sense.    data one; input record_id inddato time; datalines; 1 123 4 1 125 7 2 345 2 145 12 4 125 ; run; data two; input record_id inddato xx; datalines; 2 345 12 4 125 17 ; run; proc sql; create table test as select distinct a.* from two join b.one on a.inddato=b.inddato and a.record_id=b.record_id and record_id in (2,4) then b.time=a.xx ; quit; data want; input record_id inddato time; datalines; 1 123 4 1 125 7 2 345 12 2 145 12 4 125 17 ; run;   However this does not work. Any suggestions?    Kind regards    Solvej       ... View more

Dear SAS experts   I have the following programme where I am trying to merge my original data  (data set x with information on multiple events for individual persons) with data on medicine (dataset medicin) given four hours before the event (datetime specified in dateset x (variable called  startdatetime)).    proc sql; create table meds4hoursbefore as select x.*, medicin.* from x  left join medicin on x.Patient_RK = medicin.Patient_RK and medicin.medicinadmdatetime between (x.startdatetime - (4*60*60)) and x.startdatetime  left join x next on x.Patient_RK = next.Patient_RK and x.xnr+1 = next.xnr and next.startdatetime < medicin.medicinadmdatetime where next.Patient_RK is null order by Patient_RK, xnr ; quit;   The patient id has to match in the two datasets and the programme also has to take into account the multiple events for the individual where we each time has to match with the appropriate medicine data.    My problem is that in dataset x I have 1412 individuals with 4140 events however after merging then I still have 1412 indiduals but only 3785 event. Why am I missing events? It can not be because no medicine data fits the event because some of the 3785 events that remain in the output also dont have at medicine match.  I have 2,5 million records in my medicine data.   I hope this makes sense,    Kind regards    Solvej  ... View more

Dear SAS experts   I hope somebody can help solve a data management problem. I have to datasets (have1 and have2) that I want to merge based on two variables (record_id and number), however I dont want the first dataset have1 to be overwritten but instead data to be added where missing. I hope this makes sense. Where data have been added in the want dataset it has been marked with bold.   Kind regards Solvej     Have1                                 record_id number A1 B1 C1 A2 B2 C2                   1 17 1 c c 8 t t                   2 2                               3 1 8 f f                                                           Have2                                 record_id number A1 B1 C1 A2 B2 C2 A3 B3 C3             1 17 2 b w 4 s h 6 kk gg             2 2 3 s x 5 s g                   3 1 4 x x                                                           Want                                 record_id number A1 B1 C1 A2 B2 C2 A3 B3 C3 A4 B4 C4 A3 B3 C3 1 17 1 c c 8 t t 2 b w 4 s h 6 kk gg 2 2 3 s x 5 s g                   3 1 8 f f 4 x x                                                     ... View more