Print Line of Text to Tagsets.ExcelXp

[wcp_fnfg]

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

[Chevell_sas · Accepted solution]

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

[wcp_fnfg]

Yup that works.

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

[Cynthia_sas]

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;