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

When a percent sign is included in the data, this character is stripped
when rendered by the ODS Markup destination. Therefore, any destination
such as such as CSV, HTML, EXCELXP and any other tagset generated will
have this same problem.

If you are using the ODS HTML destination, you can use the ODS HTML3
statement as a workaround to this problem. The data can also be modified
to add an extra percent in front of the current one, or spaces. This may
also remove trailing charater as well.

The example below demonstrates the problem encountered with the embedded
percent character.

   data test_percent;
   infile datalines;
   input txt_col $16.;
   datalines;
   P%NS_D
   P%92345NS_D
   P%a92345NS_D
   P%b92345NS_D
   P%c92345NS_D
   P%d92345NS_D
   P%2B5NS_D
   ;
   run;

   ods listing close;
   ods html file="c:\temp.html";

   proc print data=test_percent;
   run;

   ods html close;

Operating System and Release Information