topic Re: ods excel proc report output in SAS Programming

ods excel proc report output

JHE — Tue, 22 Aug 2017 19:20:11 GMT

My code:

ODS LISTING CLOSE;

ods excel file="/mnt/nfs/prod/Sched/OpsDeptData/Operations/Reports/Rework/&dtMonth._Rework.xlsx"

style=Print;

ods excel options(

sheet_name = '0100'

embedded_titles='yes'

EMBEDDED_FOOTNOTES= 'Yes'

sheet_interval="table"

orientation='landscape'

);

RUN;

PROC REPORT DATA=REWORKO.REWORK0100_SUMAMRY

STYLE(COLUMN)= [font_size=10 pt cellwidth=.14 in height=.2in]

style(header)=[font_size=11 pt height=.4in background=silver ]

style(summary)=[font_weight=bold];

/*define LOB / style(column)=[cellwidth=.6in];*/

define LOB/style(column)={tagattr='Format:Text:$4.' just=left cellwidth=0.6 in};

run;

ods _all_ close;

LOB =0100, but when ods to excel output , LOB = 0100,

what I should do can fix this.

PaigeMiller — Tue, 22 Aug 2017 19:40:58 GMT

I am unable to understand the problem description.

JHE — Tue, 22 Aug 2017 19:43:08 GMT

I have

LOB = 0100, there is a leading Zero.

After ods excel using PROC REPORT,

define LOB/style(column)={tagattr='Format:@' just=center cellwidth=0.9 in};

the excel file , LOB has the value =100, missing the leading zero.

ballardw — Tue, 22 Aug 2017 20:42:29 GMT

You may want to edit your orginial post where it says:

LOB =0100, but when ods to excel output , LOB = 0100,