Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

To get around this problem, the Excel Text format can be applied so that the value comes over the same way it was displayed in SAS. How this is done depends on the ODS destination that you use to generate the file. If the ExcelXP destination is used, the Excel text format can be applied using the format: parameter within the TAGATTR= attribute. Using the MSOffice2k/HTML/HTML3 destinations, the Microsoft Office CSS style property mso-number-format can be used with the same text format. Select the Full Code tab to see example code.

Operating System and Release Information

data one;
  input account name $;
cards;
023456 Bob
054556 Henry
034456 Wes
;
run;

/* ExcelXP destination */

ods tagsets.ExcelXP file="temp.xls";

proc print data=one;
var name;
var account / style(data)={tagattr="format:@"};
format account z6.;
run;

Ods tagsets.ExcelXP close;


/* MSOffice2k destination */


ods Msoffice2k file="temp1.xls";

proc print data=one;
var name;
var account / style(data)={htmlstyle="mso-number-format:\@"};
format account z6.; 
run;

Ods msoffice2k close;