Help with proc export

New Contributor Hm2
New Contributor
Posts: 2

Help with proc export


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";


Super User
Posts: 23,659

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,909

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:


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
  • 1 like
  • 3 in conversation