options pageno=1; proc greplay nofs igout=gseg; delete _all_; *the PROC IMPORT statment below imports the input file from the destination on the computer where it is stored. Path to the input file must be edited accordingly.*; /* PROC IMPORT OUT= WORK.spent DATAFILE= "C:\Users\Amrita\Dropbox\AmritaData\SAS\Figure S1 Raw Data.xlsx" DBMS=EXCEL REPLACE; RANGE="Input$"; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; */ ODS PDF file='\\Client\H$\Desktop\FigureS1Results.pdf'; /*Here we average the replicate wells for each expt and bactsource*/ proc sort data=spent; by expt bactsource; run; proc means data=spent noprint; by expt bactsource; var lagtime; output out=expsum mean(lagtime)=avglag; run; title 'Averaging Wells with each Experiment'; proc mixed data=expsum covtest; class bactsource; model avglag=bactsource; estimate 'Used Bact vs. Bact Ctl' bactsource -1 0 0 1 0/cl; lsmeans bactsource/pdiff; run; ods pdf close;