I have tried several different ways to prevent excel from showing a field as scientific notation in my outputs. the latest of the code is below using format:# I have tried format: text, I tried different widths. In Excel, the output always defaults to "General". If I change it manually to Numeric with no decimals it shows the correct number but programmatically I can not get this work. This is what I get in Excel and below that is the code I last used: PROC REPORT DATA = work.output nowd headline headskip split='*'
style(header)=[font_face='Arial' font_size=9pt font_weight=bold background=lightgrey foreground=black just=c tagattr='wrap:yes']
style(column)=[font_face='Arial' font_size=9pt just=l tagattr='wrap:no'];
Define TrackingNumber / display "Internal Tracking ID" style={TAGATTR="format:#" width=1.5in};
RUN;
... View more
