DATA Step, Macro, Functions and more

ods excel proc report output

Reply
Frequent Contributor
Frequent Contributor
Posts: 119

ods excel proc report output

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.

 

 

 

 

Respected Advisor
Posts: 2,854

Re: ods excel proc report output

I am unable to understand the problem description.

--
Paige Miller
Frequent Contributor
Frequent Contributor
Posts: 119

Re: ods excel proc report output

Posted in reply to PaigeMiller

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.

 

 

Super User
Posts: 13,365

Re: ods excel proc report output

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

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

 

 

 

Ask a Question
Discussion stats
  • 3 replies
  • 163 views
  • 0 likes
  • 3 in conversation