The SAS Output Delivery System and reporting techniques

keep formatting for Proc Export

Reply
New Contributor Hm2
New Contributor
Posts: 2

keep formatting for Proc Export

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;

PROC Star
Posts: 7,428

Re: keep formatting for Proc Export

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.

 

Ask a Question
Discussion stats
  • 1 reply
  • 524 views
  • 0 likes
  • 2 in conversation