I have the following dataset: ID order status time_group 1234 1 increase 0 to 6 hours 1234 2 increase 12 to 24 hours 1234 3 decrease 24 to 48 hours 1234 4 increase 24 to 48 hours 2342 1 increase 0 to 6 hours 2342 2 decrease 12 to 24 hours 2342 3 increase 12 to 24 hours 2342 4 increase 24 to 48 hours 2342 5 decrease 24 to 48 hours   What I would like to do is extract max order ID and status by time group. For example, in ID 2342, there are two 24 to 48 hours but with differing status (i.e. increase and decrease). What I would like to do is keep the max order number for that. So keep decrease for group 24-48 hours.   Something like this below: ID order status time_group 1234 1 increase 0 to 6 hours 1234 2 increase 12 to 24 hours 1234 4 increase 24 to 48 hours 2342 1 increase 0 to 6 hours 2342 3 increase 12 to 24 hours 2342 5 decrease 24 to 48 hours   I did the following proc sql; create table want as select distinct ID, timegroup, status, max(order) as ID from have  group by ID, timegroup, status;quit;   not getting what i want ... View more

I have the following table below. What I would like to do is that  If category_1 = 'AAA' and category_2 = 'Yes' then Group_1 through Group_4 should delete '(100.0%)'.    Have   Category_1 Category_2 Group_1 Group_2 Group_3 Group_4 AAA Yes 8 (100.0%) 12 (100.0%) 3 (100.0%) 13 (100.0%) BBB Yes 2 (25.0%) 6 (50.0%) 1 (33.3%) 10 (76.9%) BBB No 6 (75.0%) 6 (50.0%) 2 (66.7%) 3 (23.1%)   Want:   Category_1 Category_2 Group_1 Group_2 Group_3 Group_4 AAA Yes 8 12 3 13 BBB Yes 2 (25.0%) 6 (50.0%) 1 (33.3%) 10 (76.9%) BBB No 6 (75.0%) 6 (50.0%) 2 (66.7%) 3 (23.1%)   I am not sure how to do it. I tried catx and strip ... View more

I have the following dataset. What I want to do is create a new time_3 column that uses the FIRST date. if one of them is missing, use the one that is available.    subjectid time_1 time_2 1 1/2/2012 1:50   2 1/4/2012 13:53 1/3/2012 1:50 3 1/5/2012 1:50 2/6/2012 9:32 4   1/9/2019 12:12   subjectid time_1 time_2 time_use 1 1/2/2012 1:50   1/2/2012 1:50 2 1/4/2012 13:53 1/3/2012 1:50 1/3/2012 1:50 3 1/5/2012 1:50 2/6/2012 9:32 1/5/2012 1:50 4   1/9/2019 12:12 1/9/2019 12:12   I had to do in two data sets and is there any one step that solves all?  data want; set have; if time_1 < time_2 then time_use= time_1; else if time_2 < time_1 then time_use= time_2; format time_use datetime16.;run; run;   data have; set have; if time_use= . and ventstopdtm = . then time_use= time_2; else if time_use= . and time_2 = . then time_use= time_1 ; else time_use= time_use; format time_use datetime16.; run; ... View more

Hi i have the following table:   group reasons total_events 1 a 5 1 b 1 1 c 3 1 d 2 2 a 4 2 b 3 2 c 11 2 d 4   What I want is the frequency total by group as denominator; something like this:   group reasons total_events total_denominator 1 a 5 11 1 b 1 11 1 c 3 11 1 d 2 11 2 a 4 22 2 b 3 22 2 c 11 22 2 d 4 22   I tried the following but i get 100% for all.    ods output onewayfreqs=test_owf;/*one way frequency*/ proc freq data=o.have; table reasons; by group; run; ods listing; ... View more

Hi I have the following dataset. What I would like to do is FIRST instance and LAST INSTANCE per patient, I would like the duration to be the same. But for the middle, i would like to set up duration = 24.    patientID time first_date_time stop_date_time duration weight 111 1 1/2/2020 1:20 1/2/2020 23:59 22 24 111 2 1/3/2020 0:00 1/3/2020 21:23 21 24 111 3 1/4/2020 2:00 1/4/2020 18:18 16 24 222 1 2/1/2020 9:20 2/1/2020 23:59 14 19 222 2 2/2/2020 0:00 2/2/2020 19:12 19 19 222 3 2/3/2020 3:00 2/3/2020 20:23 17 19 222 3 2/4/2020 1:00 2/4/2020 23:23 22 19   This: patientID time first_date_time stop_date_time duration weight duration_final 111 1 1/2/2020 1:20 1/2/2020 23:59 22 24 22 111 2 1/3/2020 0:00 1/3/2020 21:23 21 24 24 111 3 1/4/2020 2:00 1/4/2020 18:18 16 24 24 222 1 2/1/2020 9:20 2/1/2020 23:59 14 19 14 222 2 2/2/2020 0:00 2/2/2020 19:12 19 19 24 222 3 2/3/2020 3:00 2/3/2020 20:23 17 19 24 222 3 2/4/2020 1:00 2/4/2020 23:23 22 19 22 It didnt work:   data want; set have;    by PatientID time;    if first. time then  do;   duration_final = duration  end;    else  if last. time then   do;  duration_final = duration end;    else  do;  duration_final = 24 end; run; ... View more

I have two dataset with different variable formats   dataset #1 reasons group1 group2 reason1 1 (6%) 10 (48%) reason2 4 (22%) 7 (33%) reason3 6 (33%) 1 (5%) reason4 7 (39%) 3 (14%)   group1 and group2 format are both $22.;   dataset2; reasons group1 group2 TOTAL 18 21   group1 and group2 are best12.;   i want to combine using UNION both tables to this:   reasons group1 group2 reason1 1 (6%) 10 (48%) reason2 4 (22%) 7 (33%) reason3 6 (33%) 1 (5%) reason4 7 (39%) 3 (14%) TOTAL 18 21   I did: proc sql;  create table want_merge as select  * from dataset1 union all select * from dataset2; quit;   I am getting error "group 1 has been defined as both character and numeric' . i changed the format in each dataset to 22.; but still not work ... View more