Format Decimals Where One Doesn't Exist

[shelby55]

Hello

I'm using SAS 9.3.

I have a program that I've created in SAS and I'm exporting lots of data to Excel. Currently there are fields for length of stay that don't have decimal points but I want to add one.

In the export part of the code I have indicated:

format los 7.1 acute 7.1

but it doesn't work.

This sounds like such an easy thing but I have searched the internet and can't find it...I forgot there was a SAS group on TekTips so hopefully you can help.

Thanks.

 

[sasbuddy]

Many a times format in SAS wont directly get applied to EXCEL.
Better use the format in EXCEL itself.

sasbuddy

http://sites.google.com/site/sasbuddy/

 

[shelby55]

Thanks SASBuddy, I'll do that!