You can use the NWAY option for this. Note that Proc means or summary will not calculate means for missing values, so you have to exclude the missing value. I have taken variable1_mean and median, You can include all the other variable in the VAR statement and also in the Mean and Median statements for the output. Please refer to the link below for more details on Proc means.   https://www.9to5sas.com/proc-means/    data have; input subject day group $9. variable1_Mean; datalines; 2 0 placebo 2 1 0 treatment 1 3 0 treatment 2 2 1 placebo 2 1 1 treatment 1 3 1 treatment 1 2 2 placebo . 1 2 treatment 2 3 2 treatment 2 3 3 treatment 1 3 3 treatment 2 3 3 treatment 3 3 3 treatment 4 ; run; proc summary data=have(WHERE=(variable1_Mean ^=.)) mean median nway; class group day; var variable1_Mean; output out=want (drop=_type_ _freq_) mean=variable1_Mean median=variable1_Median; run; ... View more

proc sql; create table included as select * from table1 where ID in (select ID from table2); quit; proc sql; create table excluded as select * from table2 where ID not in (select ID from table2); quit; Here are two examples on how to include from a subset of IDs or exclude a subset of IDs.    @aishajennifer1 wrote: 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

1. Get a list of ID's that have a 1 indicator 2. Merge or filter your second data set by the list in the first.    For a beginner the best solution IMO would be @ed_sas_member solution.  ... View more

Use the scan() function to extract the 3rd, 2nd and 5th "word", concatenate and use the date9. informat to convert to a date. Use the time8. informat on the 4th "word", and then you can build the datetime from the date and time.   @aishajennifer1 wrote: 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

data want; if _n_=1 then do; dcl hash H () ; h.definekey ("start_date_time") ; h.definedata ("new_stop_date") ; h.definedone () ; end; do _n_=1 by 1 until(last.id); set have ; by id; if stop_date_time then _s=stop_date_time; if method=2 then do; _iorc_+1; _k=lag(start_date_time); if _iorc_>1 then h.add(key:_k,data:start_date_time); end; end; do _n_=1 to _n_; set have; if method ne 2 then call missing(new_stop_date); else if h.find() ne 0 then new_stop_date=ifn(_s,_s,static_date_time); output; end; call missing(_iorc_); h.clear(); format new_stop_date datetime20.; drop _:; run; proc print noobs;run; ID method start_date_time static_date_time stop_date_time new_stop_date 1 1 01JAN19:11:13:00 11JAN19:15:12:00 . . 1 2 01JAN19:12:15:00 11JAN19:15:12:00 . 02JAN2019:20:33:00 1 1 01JAN19:16:11:00 11JAN19:15:12:00 . . 1 1 02JAN19:18:11:00 11JAN19:15:12:00 . . 1 2 02JAN19:20:33:00 11JAN19:15:12:00 . 04JAN2019:21:12:00 1 1 03JAN19:12:12:00 11JAN19:15:12:00 04JAN2019:21:12:00 . 2 1 01JAN19:11:13:00 11JAN19:15:12:00 . . 2 2 01JAN19:12:15:00 11JAN19:15:12:00 . 02JAN2019:20:33:00 2 1 01JAN19:16:11:00 11JAN19:15:12:00 . . 2 1 02JAN19:18:11:00 11JAN19:15:12:00 . . 2 2 02JAN19:20:33:00 11JAN19:15:12:00 . 11JAN2019:15:12:00 2 1 03JAN19:12:12:00 11JAN19:15:12:00 . . ... View more