08-02-2015 06:24 AM
hi I have a table that divede one amt into another an it comes out with a decimal I need to add the % sign to the output
( sales/ inventory)as percentage_sales;
5/10. = 0.5 I need to read 50% ...thanks for your assistance in this matter
08-03-2015 09:24 AM
It applied the symbol but when I export it was removed an reverted back to decimal ... How can I keep the symbol when it's exporting out to excel? Thanks
08-03-2015 09:29 AM
Post example data in the forma of a datastep, and describe how you are exporting the data. Generally speaking, I would be using the tagsets.excelxp and a proc report, so would just add the Excel format to the column:
But it depends on how your data is, and how you are exporting.
08-03-2015 11:35 AM
I Have a table like this
(a.sales/a.inventory) as percent format= percent8.,
from want a left join table b. On a.no=b.no
Proc export data = want1
08-04-2015 03:49 AM
Yes, that will work. I would recommend however you 1) don't use proc export, it is a guessing procedure, i.e. it guesses what you want to do. 2) use proc report and ods tagsets.excelxp, this has a lot more functionality, and you can set formats as per the link I gave you.
Need further help from the community? Please ask a new question.