Hi there,   I am having a data consisting of multiple transactions for a person within a same day but some of the records for the same person is missing e.g site ID. I want to fill the missing site ID by taking value from one of the site ID from the transactions of that person on the same date assuming that in a day all transaction occurs in one site only. Can some one kindly help me to move forward.  data have; input name $ service_date site_ID ; cards; aaa 20140102 101 aaa 20140102 bbb 20140102 102 ccc 20140104 103 ccc 20140104 ccc 20140104 103 aaa 20140105 104 aaa 20140105 aaa 20140105 104 ; run; data want; input name $ service_date site_ID ; cards; aaa 20140102 101 aaa 20140102 101 bbb 20140102 102 ccc 20140104 103 ccc 20140104 103 ccc 20140104 103 aaa 20140105 104 aaa 20140105 104 aaa 20140105 104 ; run;   Thank you in advance for your kind reply.    Regards,   ... View more

Hi there,   I am looking for the shortest positive date difference.  But if the date difference value is negative and is smaller than shortest postive date difference then I want the negative difference . In other word, out of the following date differences: 5, 2, -3: I want to flag 2  [as 2 is shortest positive and is less than (-)3] whereas out of the following date differences: 5, 4, -3: I want to flag -3 [as 4 is shortest but is more than (-)3 ] .   I am having difficult at my final step of my SAS code.  data test1; input id date1 $9. date2 $9. ; cards; 1 11012016 13012016 1 11012016 15012016 1 11012016 10012016 1 11012016 11012016 2 11012016 20012016 2 11012016 15012016 2 11012016 16012016 2 11012016 08012016 ; run; data test2; set test1 (rename= (date1=date3 date2=date4)); date1=input(put(date3, 8.), ddmmyy8.); date2=input(put(date4, 8.), ddmmyy8.); format date1 date2 date9.; date_diff=intck('DAY', date1, date2); run; proc sort data =test2 ; by id date_diff; run; Can somebody help me with this. Thank you in advance for your kind reply.  ... View more

Hi there, I am trying to generate record of each person having maximum and minimum bp with respective dates. Sample of dataset is as follows: data test; input id bp date $ ; cards; 1 100 20160110 2 110 20160111 3 150 20160112 1 110 20160112 2 130 20160113 3 130 20160114 1 140 20160113 2 150 20160114 3 120 20160115 1 120 20160114 2 120 20160115 3 160 20160116 1 150 20160115 2 140 20160116 3 130 20160117 ; run; Wanted: id    max_bp           date_having_max_bp               min_bp             date_having_min_bp 1     150                   20160115                                  100                  20160110   Can somebody help me to do that. Thank you in advance for your kind reply.  ... View more

Hi tjhere, For your kind information, I am trying to exclusion criteria for colon cases by flagging "Pre-negation phrase" and "Post negation" phrase.  For example, report having the statement "NO EVIDENCE OF CARCINOMA IS SEEN IN THE COLON" will be flagged as "NO_CARCINOMA=1" as "no evidence of" is present  either before or after the term colon within 10 words. As my reprts may contains multiple lines, I want to specify the word distance. Can somebody help me to write a code to flag it. First I want to identify the term "COLON" with the report and then within 10 words on either side of it, I want to identify presence of the negation term "NO EVIDENCE OF CARCINOMA ".   Sample of data: data test; length text $200; id=1; text="NO EVIDENCE OF CARCINOMA IS SEEN IN THE COLON."; output; id=2; text="SPECIMEN OF COLON SHOWS NO EVIDENCE OF CARCINOMA BUT THERE IS SOME DYSPLASIC CHANGES"; output; id=3; text="ASCENDING COLON IS HAVING DEFINITIVE EVIDENCE OF CARCINOMA "; output; id=4; text="SIGMOID COLON IS HAVING MULTIPLE POLYP AS WELL AS FIRBROSIS. SPECIMEN OF LIVER IS ALSO HAVING NO EVIDENCE OF CARCINOMA "; output; run; Thank you in advance for your kind guidance.  Regards, Deepak   ... View more

Hi there, I am looking for a sql code to combine two tables: admission and insurance where a person having coverage in part by 2 insurance companies following each admission. I came across example in community that suggest use of multiple set statements. I am interested to know the possible solution using sql code. data admission; input id $ date $ ; datalines; 1 10102015 1 11103015 ; run; data insurance; input id $ company $; datalines; 1 MOH 1 sunlife ; run; /*merge not allow many to many relation*/ proc sort data =admission; by id ; run; proc sort data =insurance; by id ; run; data merged; merge admission (in=a) insurance(in=b); by id; if a=b; run; Thank you in advance for your kind reply. Regards, Deepak  ... View more