I have two datasets:   dataset#1: patientid value 1 143 2 123 3 123 4 5 4212 321   dataset#2 patientid height 2 44 3 12   I want to create a dataset NOT to include patient from dataset#2   patientid value 1 143 4 4212 5 321   I tried using MINUS and intersect but no avail   Any help would be great!! ... View more

I am trying to do the proc means by day and treatment but I am not finding the right SubjectID day group variable1_Mean variable2_Mean variable3_Median variable3_Median 2 0 placebo 2 2 16 0 1 0 treatment 1 3 11 0 3 0 treatment 2 1 12 0 2 1 placebo 2 2 54 122 1 1 treatment 1 5 7 2.5 3 1 treatment 1 1 14.5 2 2 2 placebo . 1 . 0 1 2 treatment 2 1 12 3 3 2 treatment 2 1 14 4   Something like this:   Day group variable1_Mean variable2_Mean variable3_Median variable3_Median 0 treatment 1.5       1 treatment 1       2 treatment 2       0 placebo 2       1 placebo 2       2 placebo           I did the following: proc sort data= have; by day group; run;   proc means data = have out = stat; by day group; var Variable1_Mean -- Variable3_Median  n= mean= lclm= uclm= median= min= max= nmiss=/autoname;   proc means data=have; by day group; var variable1_mean -- variable3_median; output out=want n= mean= lclm= uclm= median= min= max= nmiss=/autoname; run;   ... View more

I have the following dataset   subject flag bmi 1 1 23 1 1 23 1   23 2   25 2   25 2   25   What I want to do: If the patient has any instance of flag = 1, I would like to pull all the data records into a diff dataset. Want: subject flag bmi 1 1 23 1 1 23 1   23   I tried proc sql; create table want as select * from have having = null;quit;   Really stuck. ... View more

I currently have the date/time format in this: "Thurs Dec 19 12:30:31 2019"   I would like to create a new variable so that I am just shown date/time: 19DEC19 12:30:31"   How do I do this?   I am using this as my guide but there is no format that falls in the category above: https://v8doc.sas.com/sashtml/lrcon/zenid-63.htm ... View more

Hello. I have complex dataset that I am unsure on how to begin.    For example - there are multiple rows per subject stratified by "method" 1 or 2. - If a subject has a "method=2" then I would like to take the next record of method = 2 instance for the same subject start date and make that as an end date, and repeat. If there is no more method =2 & (stop date IS available for method =1, i would like to make that as new_stop_date time OR if stop_date is NOT available for last method = 1 then I would like to assign static_date_time = new_stop_date_time.   Sample dataset   ID method start_date_time stop_date_time static_date_time 1 1 1/1/19 11:13 AM   1/11/2019 15:12 1 2 1/1/19 12:15 PM   1/11/2019 15:12 1 1 1/1/19 4:11 PM   1/11/2019 15:12 1 1 1/2/19 6:11 PM   1/11/2019 15:12 1 2 1/2/19 8:33 PM   1/11/2019 15:12 1 1 1/3/19 12:12 PM 1/4/2019  21:12:00 PM 1/11/2019 15:12 2 1 1/1/19 11:13 AM   1/11/2019 15:12 2 2 1/1/19 12:15 PM   1/11/2019 15:12 2 1 1/1/19 4:11 PM   1/11/2019 15:12 2 1 1/2/19 6:11 PM   1/11/2019 15:12 2 2 1/2/19 8:33 PM   1/11/2019 15:12 2 1 1/3/19 12:12 PM   1/11/2019 15:12   New dataset   ID method start_date_time stop_date_time static_date_time new_stop_date 1 1 1/1/19 11:13 AM   1/11/2019 15:12   1 2 1/1/19 12:15 PM   1/11/2019 15:12 1/2/19 8:33 PM 1 1 1/1/19 4:11 PM   1/11/2019 15:12   1 1 1/2/19 6:11 PM   1/11/2019 15:12   1 2 1/2/19 8:33 PM   1/11/2019 15:12 1/4/2019  21:12:00 PM 1 1 1/3/19 12:12 PM 1/4/2019  21:12:00 PM 1/11/2019 15:12   2 1 1/1/19 11:13 AM   1/11/2019 15:12   2 2 1/1/19 12:15 PM   1/11/2019 15:12 1/2/19 8:33 PM 2 1 1/1/19 4:11 PM   1/11/2019 15:12   2 1 1/2/19 6:11 PM   1/11/2019 15:12   2 2 1/2/19 8:33 PM   1/11/2019 15:12 1/11/2019 15:12 2 1 1/3/19 12:12 PM   1/11/2019 15:12     I tried to use proc sql max stop date time per patient to join but I think I am doing it completely wrong   Thanks so much for your help in advance!! ... View more