PROC IMPORT OUT= WORK.YOURNAME DATAFILE= "C:\FOLDERS\FILENAME.XLS" DBMS=excel2000 REPLACE; *GETDELETED=NO; RUN; proc fsprint data = YOURNAME; run; proc sort data = YOURNAME; by GROUPINGVARIABLE; run; TITLE1 'GEE model'; proc genmod data = YOURNAME descending; class GROUPINGVARIABLE INDEPENDENT1 INDEPENDENT2 INDEPENDENT3; *ABOVE ONLY INCLUDES CATEGORICAL VARIABLES, BUT MUST INCLUDE GROUPING VARIABLE; model RESPONSE = INDEPENDENT1 INDEPENDENT2 INDEPENDENT3 INDEPENDENT4/ dist = binomial corrb; repeated subject = GROUPINGVARIABLE / corr=CS modelse; *MAY CHANGE CORR= TO OTHER CORRELATION STRUCTURES, E.G., INDEPENDENT, AR(1), MDEP(SEE INSTRUCTIONS), UNSTRUCTURED; output out=RESIDS predicted=inverselogit reschi=pearsresid stdreschi=stpearsresid STDXBETA=stdxbeta xbeta=logit; Run; Proc export data=RESIDS OUTFILE="C:\FOLDERS\GEE_CSRESIDS.xls" DBMS=EXCEL2000 REPLACE; run;