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.
I am unable to understand the problem description.
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.
You may want to edit your orginial post where it says:
LOB =0100, but when ods to excel output , LOB = 0100,
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.