BookmarkSubscribeRSS Feed
rkolupoti9001
Calcite | Level 5

Hi,

Am having a dataset where am calculating the percentages and when am trying to export it to excel by proc export the format is not the same as it was in sas for calculation.

Can anybody let me know how to keep the same format in excel ?

calculation in sashave format in excelwant format in excel
60%0.6060%

Thanks in Advance!!!!

2 REPLIES 2
Reeza
Super User

Search on here for a variety of solutions Smiley Happy

sivastat08
Pyrite | Level 9

kindly refer below subject for solution

 

"How to retain the Variable Format when PROC EXPORT TO EXCEL"

 

Thanks,

Siva

 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1481 views
  • 0 likes
  • 3 in conversation