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
To prevent this behavior, you can use the tagset option Ascii_dots="no". The default of this option is yes.
To prevent this behavior, you can use the tagset option Ascii_dots="no". The default of this option is yes.
Yup that works.
Any idea how to style that text, like bold, italics, weight, etc?
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.