Team, I am trying to generate Excel report with multiple sheet. for this i am using the below given code. My problem is even though i am specifying multiple sheet name in the code, All are coming in a single sheet. ods excel file="Operationsreport.xls" ; ods excel OPTIONS ( embedded_titles="yes" sheet_interval="none" sheet_name="Account Opening" ) proc sql; select item_desc ,field1 ,field2 from table1 order by item_code; proc sql; select item_desc ,field1 ,field2 from table2 order by item_code; quit; run; ods excel OPTIONS ( embedded_titles="yes" sheet_interval="none" sheet_name="Modification Process" ); proc sql; select item_desc ,field1 ,field2 from table3 order by item_code; proc sql; select item_desc ,field1 ,field2 from table4 order by item_code; quit; run; ods _all_ close; The sheet_interval="none" option is not working i guess. Please guide. regards, Aneesh
... View more