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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: