SAS ODS

%let output_loc=\\Hqdellsas04\exports\APJ\Test ;data outTable;format country_2char $8. dim_plat_person_id F20.dim_plat_email_sid F20.;informat country_2char $1200. dim_plat_person_id F20. dim_plat_email_sid F20.;set smb_prod.email_bau_100  ;keep country_2char dim_plat_person_id dim_plat_email_sid ;label country_2char='Country 2Char' dim_plat_person_id='Dim Plat Person Id' dim_plat_email_sid='Dim Plat Email Sid';run;ods listing close;ods tagsets.ExcelXP body="&output_loc.\test.xls" style=analysis;Title '!00 Sample records';Title2 'Test';ods tagsets.ExcelXP options(sheet_name="Sheet1");proc print data=outTable noobs;run;ods tagsets.ExcelXP options(sheet_name="Sheet2");proc print data=outTable noobs;run;ods Tagsets.ExcelxP close;ods listing;/*ODS HTML file="&output_loc./test.html" style=analysis;proc print data=outTable noobs ;run;ODS HTML close;