Help with proc export

Reply
New Contributor Hm2
New Contributor
Posts: 2

Help with 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\sha​red\sales\Look to book by Territory\Key"

dbms = "XLSX" replace;

sheet = "Key";

run;

Super User
Posts: 17,776

Re: Help with proc export

That's mostly an Excel issue. Some workarounds are to use a different method of export - ODS (TAGSETS.EXCELXP or EXCEL).

Another is to write the field as a character string and then see if Excel converts it, though it may cause other issues in Excel.
Super User
Posts: 3,102

Re: Help with proc export

See this link for the default conversions that SAS performs based on the SAS format applied to the column - this is what you are experiencing:

 

http://support.sas.com/documentation/cdl/en/acpcref/67382/HTML/default/viewer.htm#n0cfqhcraieg81n1ie...

 

You might want export it from SAS formatted as a plain numeric then change it in Excel yourself, or if you want SAS to do it try Reeza's suggestions.

 

 

Ask a Question
Discussion stats
  • 2 replies
  • 221 views
  • 1 like
  • 3 in conversation