The SAS Output Delivery System and reporting techniques

Print Line of Text to Tagsets.ExcelXp

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 84
Accepted Solution

Print Line of Text to Tagsets.ExcelXp

I can use data _null_ and file print, but not matter what, when it shows up in excel, it has a period in front of the text.  Any alternatives\fixes?

data _null_;

file print;

put 'Hi Wes';

run;

Ends up as

.Hi Wes  

(The period is not present in the output window, just excel.

EG5.1


Accepted Solutions
Solution
‎07-28-2014 05:05 PM
SAS Employee
Posts: 88

Re: Print Line of Text to Tagsets.ExcelXp

To prevent this behavior, you can use the tagset option Ascii_dots="no". The default of this option is yes.

View solution in original post


All Replies
Solution
‎07-28-2014 05:05 PM
SAS Employee
Posts: 88

Re: Print Line of Text to Tagsets.ExcelXp

To prevent this behavior, you can use the tagset option Ascii_dots="no". The default of this option is yes.

Frequent Contributor
Posts: 84

Re: Print Line of Text to Tagsets.ExcelXp

Yup that works.

Any idea how to style that text, like bold, italics, weight, etc?     

SAS Super FREQ
Posts: 8,820

Re: Print Line of Text to Tagsets.ExcelXp

Hi:

  You can use ODS ESCAPECHAR functions with STYLE overrides to alter the text. You could look at changing the style template. I don't remember off the top of my head which style element you would change. The Data element, I think. Or you could use a PROC REPORT approach. See the code below.
      

Cynthia

ods tagsets.excelxp file='c:\temp\data_null_xp1.xml'
    style=htmlblue options(ascii_dots='no');
ods escapechar='^';
**Method 1;
data _null_;
file print;
put '^{style[font_weight=bold font_size=12pt color=purple]Hello World}';
put 'Twas Brillig and the slithy toves';
run;
  
ods tagsets.excelxp close;
  

data world;
  length text $50;
  text = 'Hello World';
  output;
  text='Twas Brillig and the slithy toves';
  output;
run;
    
ods tagsets.excelxp file='c:\temp\proc_report2.xml'
    style=htmlblue ;
   
**Method 2;
proc report data=world nowd noheader
  style(column)={font_weight=bold font_size=12pt color=purple};
  column text;
run;

ods tagsets.excelxp close;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 763 views
  • 0 likes
  • 3 in conversation