DATA Step, Macro, Functions and more

loosing leading zeros when writing to an excel file

Reply
Regular Learner
Posts: 1

loosing leading zeros when writing to an excel file

I am writing a SAS dataset to an excel file using the FILE command, not the ODS to which I may not have permission since I am using SAS University edition.

 

Is there any commands to prevent the leading zeros from being stripped away when being written to the excel file, using the FILE command.

 

Thanks,

 

Karen

Super User
Posts: 11,343

Re: loosing leading zeros when writing to an excel file

Posted in reply to karenmongan0

Please provide example of your data and how you wrote the file if you would like any tested code provided.

You may have to force quotes into the output data otherwise it is Excel stripping the leading values, treating a variable that should be character as a number.

Super User
Posts: 10,020

Re: loosing leading zeros when writing to an excel file

Posted in reply to karenmongan0

Add a character value before it . Like : single quote( ' ) or TAB character (  '09'x  ) .

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