keep formatting for Proc Export

Hm2 — Mon, 02 Nov 2015 19:12:40 GMT

Hi,

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:

proc export

data = LookToBook_MTD_90_180

outfile = "\\acc.local\fileservices\private\riskanalysis\shared\sales\Look to book by Territory\Key"

dbms = "XLSX" replace;

sheet = "Key";

run;

Re: keep formatting for Proc Export

art297 — Mon, 02 Nov 2015 23:17:12 GMT

I'd think that the method using the libname statement might be the easiest and most versatile.