topic how to add % sign to output in SAS Procedures

how to add % sign to output

BETO — Sun, 02 Aug 2015 10:24:30 GMT

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

example

( sales/ inventory)as percentage_sales;

5/10. = 0.5 I need to read 50% ...thanks for your assistance in this matter

Re: how to add % sign to output

Ksharp — Sun, 02 Aug 2015 11:05:37 GMT

( sales/ inventory) as percentage_sales format=percent8. ;

Re: how to add % sign to output

BETO — Mon, 03 Aug 2015 13:24:30 GMT

Xia Keshan,

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

Re: how to add % sign to output

RW9 — Mon, 03 Aug 2015 13:29:14 GMT

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:

http://support.sas.com/resources/papers/proceedings10/031-2010.pdf

But it depends on how your data is, and how you are exporting.

Re: how to add % sign to output

Ksharp — Mon, 03 Aug 2015 13:54:13 GMT

You'd better post it at ODS and REPORT forum, It looks like ODS problem , You need some special style like : style={tagattr="format:@"}

Re: how to add % sign to output

BETO — Mon, 03 Aug 2015 15:35:13 GMT

I Have a table like this

a.no,

a.market,

(a.sales/a.inventory) as percent format= percent8.,

from want a left join table b. On a.no=b.no

);run;

Proc export data = want1

outfile= sharepoint

dbms=excel replace;

newfile=yes;

run;

Re: how to add % sign to output

BETO — Mon, 03 Aug 2015 19:01:44 GMT

I converted it to character it works

Re: how to add % sign to output

RW9 — Tue, 04 Aug 2015 07:49:44 GMT

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.