Hi plz find the below answer for diffrentiation of data with excel output using ods output . ODS TAGSETS.EXCELXP PATH="D:\GSKBIO\USERS\SSP\VARDHAN\Histo pCR" FILE="&out..xls" STYLE=sansPrinter; PROC REPORT DATA= sashelp.classNOWD; COLUMN _ALL_ ; COLUMN zebrarows ; DEFINE zebrarows / COMPUTED NOPRINT; COMPUTE zebrarows ; IF sex= "M" THEN CALL DEFINE (_ROW_ ,'STYLE', 'STYLE=[BACKGROUND=#e0ffff]' ); ENDCOMP; RUN; ODS TAGSETS.ExcelXP CLOSE; yes its work for 9.2 and above versions only . this code generates data as i expected , thanks to every one .
... View more