Thank you, @Reeza! I also found a publication that is in the right direction (please see attached). The paper contains a macro that searches text files in folders for a word and returns their names if the word is there. I could save the xcel files in .csv format that is similar to text and see what the %strsrch macro does. I would rather automate file coversion as well. I would really want to know if this macro was already made into a SAS procedure.  ... View more

I did not notice the Month variable. ... View more

The first step is to create groups by type:   proc sort data=have; by type; run;   data h; set have; group + 1; by type; if first.type then group = 1; run;   Concatenate groups with either "Total" or "Delta" for transposed column names. I would transpose totals and deltas separately then merge.  e.g., name = catx("Total", "_", group); ... View more

Sequential inactivation, yes :). I decided why not stretch a table next to a graph instead. It will look just as good. ... View more

I can put population numbers in columns to the right, but am not sure which part of code is responsible for those columns (https://blogs.sas.com/content/graphicallyspeaking/files/2012/02/Full-SAS-93-Code.txt) /*--Set up columns to create the stat tables--*/ OR='OR'; LCL='LCL'; UCL='UCL'; WT='Weight'; datalines; Modano (1967) 1 0.590 0.096 3.634 1 Borodan (1981) 1 0.464 0.201 1.074 3.5 Leighton (1972) 1 0.394 0.076 2.055 2 Novak (1992) 1 0.490 0.088 2.737 2 Stawer (1998) 1 1.250 0.479 3.261 3 Truark (2002) 1 0.129 0.027 0.605 2.5 Fayney (2005) 1 0.313 0.054 1.805 2 Modano (1969) 1 0.429 0.070 2.620 2 Soloway (2000) 1 0.718 0.237 2.179 3 Adams (1999) 1 0.143 0.082 0.250 4 Truark2 (2002) 1 0.129 0.027 0.605 2.5 Fayney2 (2005) 1 0.313 0.054 1.805 2 Modano2 (1969) 1 0.429 0.070 2.620 2 Soloway2(2000) 1 0.718 0.237 2.179 3 Adams2 (1999) 1 0.143 0.082 0.250 4 Overall 2 0.328 0.233 0.462 . ; run; ... View more

@Reeza, Thank you for a simple and elegant solution. I have just one follow-up question, I would like population numbers as a secondary y-axis on a graph like this (please also see image below): Study                          N      Modano (1967)          100 Borodan (1981)          200 How would you modify the code to accommodate the N variable?: data forest; input Study $1-16 N OddsRatio LowerCL UpperCL; format oddsratio lowercl uppercl 5.3; datalines; Modano (1967) 100 0.590 0.096 3.634 Borodan (1981) 200 0.464 0.201 1.074 ; run; title "Odds Ratios with 95% Wald Confidence Limits"; proc sgplot data=forest noautolegend; scatter y=Study x=oddsratio / xerrorlower=LowerCL xerrorupper=UpperCL markerattrs=(symbol=diamondfilled); refline 1 / axis=x; * xaxis grid type=log label="Odds Ratio (log scale)"; /* specify log scale */ * yaxis grid display=(nolabel) discreteorder=data reverse; run; Many thanks!   ... View more

Thank you, this works, but my example was over-simplified. In reality, the start would be something like 2:45 pm, and end - 3:00 pm. I would like to capture an event = 2:55 pm. Is there a way to merge conditionally to hospital day if event is between start and end?: hday   start  end event 1         2:45  3:00  2:55   ... View more

Here you go: data d1; infile datalines delimiter=' '; input hday start end; datalines; 1 1 3 2 4 6 3 7 9 ; run; data d2; infile datalines delimiter=' '; input event; 2 3 5 8 ; run; output: hday start end event 1 1 3 2 1 1 3 3 2 4 6 5 3 7 9 8 Many thanks!   ... View more

Yes, it reads "Mediator probability modeled" is 1 now. The results table did not change. I guess it does not matter which one is the reference level for binary mediator. ... View more