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
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.
Add a character value before it . Like : single quote( ' ) or TAB character ( '09'x ) .
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.