BookmarkSubscribeRSS Feed
Fluorite | Level 6



I have made sas stored procedure and then transfered output to excel. But in excel preceding zero's are missing.


e.g.   value in sas                 value in excel

           005407                         5407

           001                               1


i have tried following code.


DEFINE SERIES_BASE / DISPLAY "SERIES BASE" Style(data)={tagattr='Format: @'} FORMAT= $CHAR4.;


DEFINE SERIES_BASE / DISPLAY "SERIES BASE" Style(data)={tagattr='Format: text'} FORMAT= $CHAR4.;


DEFINE SERIES_BASE / DISPLAY "SERIES BASE" Style(data)={tagattr='Format: $'} FORMAT= $CHAR4.;


I am getting error.


Can anyone please help.


Thanks in advance


Super User

Excel interprets any data cell that contains only digits as a number and formats accordingly. That's just Excel.

You might try adding a single quote before the leading zeroes.

For reference, please post your ODS statement(s) you used for the proc report.

Diamond | Level 26 RW9
Diamond | Level 26



Your define should be - and do note whilst we are on the subject, follow some good coding practices - i.e. not all upper case or mixed case, use indentation etc. and there is a code window {i} above where you post for code.

define series_base / display "SERIES BASE" style={tagattr='Format:@'};

If that still persists you will need to post example test data in the form of a datastep and the code (formatted so it is readable) so we can have a look.



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

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.

Get the $99 certification deal.jpg



Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1 like
  • 3 in conversation