100040002           1              Hepatic 0             CT scan with contrast 100040002           4              Breast                   19           CT scan with contrast 100050001           2              Lung 0               CT scan with contrast 100050001           3              Adrenal Gland   2              CT scan with contrast 100060001           1              Lymph Node      0              CT scan with contrast 100060001           1              Lymph Node      2              CT scan with contrast 100060001           3              Skin Of The         16           Clinical exam 100090001           2              Lymph Node      0              CT scan with contrast 100090001           1              Bone     7                             MRI 100090002           1              Lymph                  0              CT scan with contrast 100090002           1              Lymph                  2              CT scan with contrast 100090002           2              Pericardium        10 Ultrasound I have dataset with 5 Variables ID,A,B,VISIT and METHOD. When A AND B are not missing, Method variable should be consistent across the visits for a particular id. If METHOD is not consistent across the visits we should pull out those records where Method is not same as the previous visit for a particular id. In the above table, The yellow records are correct and we should pull out the discrepancies marked in Red. Thanks ... View more

470010001           INITIAL DIAGNOSIS                19054                    19047 470010001           INITIAL DIAGNOSIS                19054                    19054 470010002           INITIAL DIAGNOSIS                18641                    18641 470010002           INITIAL DIAGNOSIS                18641                    18683 470010003           INITIAL DIAGNOSIS                18059                    18045 470010003           INITIAL DIAGNOSIS                18059                    18059 470010005           INITIAL DIAGNOSIS 18133                    18124 470010005           INITIAL DIAGNOSIS 18133                    18150 470010007           INITIAL DIAGNOSIS 16880                    16220 470010007           INITIAL DIAGNOSIS 16880                    17853 Hi, I have the following data with variables id, term, date1, date2 . I want create a table to select id’s whose date1 is not present in date2. In the above data  the id(470001005,470010007) marked in yellow are discrepancy  as their date 1 is not present in date2. We need to pull out those kind of records. The id’s marked in red are good as their date1 is matching atleast one of the date2 for that particular subject. ... View more

I have dataset with three varaibles id startdate enddate. Dates are numerical sas formats. I would like to pull out the records for id where the difference between the two succesive START dates is more then 28 days. There will be few missing dates too. example: ID    STARTDATE ENDDATE 001   19583      19604 001   19589      19609 001   19600      19610 001   19628      19638 001   19480      19520 002     .           . 002   19620      19624 002   19630      19634 ... View more