Hello, I have a SAS column (delay_hrs) formatted as HH:MM. When I use ODS tagsets.excel XP I can not format and bring up in Excel in the HH:MM format. When I change the format in excel to HH:MM it does not work either. In Excel it sums everything as zero and only counts the values. Here is the code ODS TAGSETS.EXCELXP FILE=_WEBOUT STYLE=STYLES.TEST OPTIONS(index='on' ORIENTATION='landscape' sheet_name="details" absolute_column_width='8' embedded_titles='yes' /*sheet_interval='none'*/); TITLE; title1 justify=center "%sysfunc(putn('&start_morning_run'd, MMDDYY8.))- %sysfunc(putn('&end_morning_run'd, MMDDYY8.))"; title2 justify=center "Daily Turn Report"; PROC REPORT DATA=work.QUERY_FOR_APPEND_TABLE_000B NOWD; column cc cc_sn turn_dt turn_ident unit1 turn_dt1 turn_ident1 wght delay_hrs Desc delay_typ desc_2 mach_strt_dttm mach_fnsh_dttm; define cc / group noprint; define cc_sn / group noprint; define turn_dt / group noprint; define turn_ident / group noprint; define unit1 / display 'Unit' style=[font_weight=bold]; define turn_dt1 / display 'Turn Dt' style=[font_weight=bold]; define turn_ident1 / display 'Turn' style=[font_weight=bold]; define wght / display 'Fin Tons' format=comma8.1; define delay_hrs / display 'Delay Hrs' format=hhmm. ; define Desc / display 'Desc' style=[font_weight=bold]; define delay_typ / display 'Delay Typ'; define desc_2 / display 'Detl Cmts' format=$1024.; define mach_strt_dttm / display 'Delay Strt'; define mach_fnsh_dttm / display 'Delay Fnsh'; compute after cc_sn; /*Line ' ';*/ endcomp; QUIT; run;
... View more