11-02-2015 02:12 PM
I am trying to export to and excel file to update a report daily. It keeps changing my format from a percentage to a decimal, how can I fix this:
data = LookToBook_MTD_90_180
outfile = "\\acc.local\fileservices\private\riskanalysis\shared\sales\Look to book by Territory\Key"
dbms = "XLSX" replace;
sheet = "Key";
11-02-2015 06:17 PM
A number of alternatives are provided in the following paper: http://support.sas.com/resources/papers/proceedings13/316-2013.pdf
I'd think that the method using the libname statement might be the easiest and most versatile.