Hi there,   For your kind information, I am trying to identify only those records which have been submitted with some changes along with the related earliest record for comparison. For example in the table mentioned below, TYPE has been changed in the most recent report with reference to the earliest report submitted in case of id 101 so it will be available in WANT table whereas id 103 will not be available in WANT table as earliest and latest value for TYPE is same. data have ; format date_1 date9. ; input id $ sp_num $ type $ date_1 yymmdd8.; datalines;101 a01 p 20160102 101 a01 b 20160102 101 a01 b 20160105 102 b02 b 20160104 102 b02 b 20160105 103 c03 p 20160106 103 c03 b 20160107 103 c03 p 20160108 104 d04 p 20160102 104 d04 b 20160104 ; run; data want ; format date_1 date9. ; input id $ sp_num $ type $ date_1 yymmdd8.; datalines; 101 a01 p 20160102 101 a01 b 20160105 104 d04 p 20160102 104 d04 b 20160104 ; run; Can anybody kindly guide me to get it.    Thank you in advance.  Regards, ... View more

Hi there,   For your kind information, I am trying to identify only those records which have been submitted with some changes. For example in the table mentioned below, TYPE has been changed in the most recent report with reference to the earliest report submitted.  data have ; format date_1 date9. ; input id $ sp_num $ type $ date_1 yymmdd8.; datalines; 101 a01 p 20160102 101 a01 b 20160103 102 b02 b 20160104 102 b02 b 20160105 103 c03 p 20160106 103 c03 p 20160107 103 c03 b 20160108 ; run; data want ; format date_1 date9. ; input id $ sp_num $ type $ date_1 yymmdd8.; datalines; 101 a01 b 20160103 103 c03 b 20160108 ; run; Can anybody kindly guide me to get it.    Thank you in advance.  Regards,   ... View more

Hi there, For your kind information, I am trying to select a group of variables having a particular string as part of its name. For e.g. from my dataset "HAVE", I want only those variable which are having " Completeness" as part of its name.  data have ; input aa_completeness bb_consistency bb_completeness cc_accuracy cc_completeness dd_consistency; datalines ; 90 80 70 60 50 40 ; run; data want ; input aa_completeness bb_completeness cc_completeness ; datalines ; 90 70 50 ; run; Thank you in advance for your kind reply to move forward.  Regards,   ... View more

Hi there,   For your kind information, I am trying to create a flag based on multiple observations for each subject. For example, multiple observations for a subject, if any observation value is missing, one missing flag will be created as well as if any of the value is invalid, an invalid flag will be created. In my example given bleow, valid range of values for category are AAA, BBB and CCC. So, if category contains DDD must be flagged as invalid.  data have; length id $3. category $3. ; infile datalines TRUNCOVER; input id $ category $; datalines; 101 AAA 101 BBB 101 CCC 201 AAA 201 201 BBB 301 AAA 301 301 DDD ; run; data want; length id $3. missing_flag $1. invalid_flag $1; infile datalines TRUNCOVER; input id $ missing_flag $ invalid_flag $ ; datalines; 101 0 0 201 1 0 301 1 1 ; run; Thank you in advance for your kind guidance.    Regards, ... View more

Hi there, For your kind information, I am having a datset with multiple intervention dates in each row which I want to transpose to get one intervention date per row. At the same time, as some of the intervention dates are missing, I want to replace with the missing intervention date with the admission date.  data have; id=1; admission_date="20140102"; intervention_1=101 ; intervention_1_date="20140102" ; intervention_2=102 ; intervention_2_date="20140103" ; intervention_3=103 ; intervention_3_date="20140103" ;output; id=2; admission_date="20140102"; intervention_1=102 ; intervention_1_date="20140102" ; intervention_2=103 ; intervention_2_date="20140102" ; intervention_3=102 ; intervention_3_date="20140104" ;output; id=3; admission_date="20140103"; intervention_1=103 ; intervention_1_date="20140103" ; intervention_2=102 ; intervention_2_date=" " ; intervention_3=101 ; intervention_3_date="20140104" ;output; id=4; admission_date="20140104"; intervention_1=103 ; intervention_1_date=" " ; intervention_2=102 ; intervention_2_date="20140104" ; intervention_3=101 ; intervention_3_date="20140105" ;output; run; data want; input id admission_date intervention intervention_date; cards; 1 20140102 101 20140102 1 20140102 102 20140103 1 20140102 103 20140103 2 20140102 102 20140102 2 20140102 103 20140102 2 20140102 102 20140104 3 20140103 103 20140103 3 20140103 102 20140103 3 20140103 101 20140104 4 20140104 103 20140104 4 20140104 102 20140104 4 20140104 101 20140105 ; run; Can somebody help me to solve the problem. Thank you in advance for your kind reply.   Regards,   ... View more