Good morning. I was wondering if anyone has come up with a solution to this problem? When I run the code below I get a "style" error when I try to open the file. When I look to the log file I get the following error. I've been going over this code for awhile but see nothing different from other code I run that seems to work. I would so appreciate any insights anyone might have regarding this problem.
Thank you very much.
XML ERROR in Style
REASON: Too many tags
FILE: C:\Users\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\IFESGBSK\MH3_assigned_special_housing 04MAY15.xls
GROUP: Styles
TAG: Style
ATTRIB: ID
VALUE: NoteContent11
title1;
title2;
title3;
footnote1;
odslisting close;
ods tagsets.ExcelXP file"F:\sasdata\attachments\FILENAME_&SYSDATE..xls"style=SASDocPrinter
style(REPORT)={cellpadding=5 background=#D0C7A8}
style(COLUMN)={font_face=Arial font_size=1 background=white}
style(HEADER)={font_face=Arial font_size=1 font_weight=bold foreground=black background=#EBE8DA};
column facility idno namel namef unitno cellno moveindt moveoutdt dsu asu imu bhu condition_code condition_type condition_description dd3need count;
define facility / group 'Inst';
define idno / 'SID';
define namel / 'Last Name';
define namef / 'First Name';
define unitno / 'Unit';
define cellno / 'Cell';
define moveindt / 'In Date';
define moveoutdt / 'Out Date';
define dsu / 'DSU';
define asu / 'ASU';
define imu / 'IMU';
define bhu / 'BHU';
define condition_code / 'BHS Code';
define condition_type / 'BHS Type';
define condition_description / 'BHS Description';
define dd3need / 'DD3';
define count / 'Count' noprint;
compute after facility / style=[font_face=Arial font_weight=bold font_size=1 foreground=black background=#DCD6BE];
line count.sum comma5. ' Inmate(s)';
line ' ';
endcomp;
compute after;
line count.sum comma5. ' People';
endcomp;
run;
ods tagsets.ExcelXP close;
ods listing;
Your tagset version is way out of date. I suggest you download and try the current version 1.130 which is still compatible with SAS 9.1.3:
Your code appears truncated - missing proc report line and end of ods tagsets call?
What version of tagsets are you using and what happens if you change the style from SASDocPrinter - Journal may be a good one.
Thank you very much for the response. I didn't realize I hadn't pasted in all the code. It is below. We are using tagset 9.1.3, v1.28 8/29/2005
title1;
title2;
title3;
footnote1;
ods listing close;
ods tagsets.ExcelXP file= "F:\sasdata\attachments\MH3_assigned_special_housing &SYSDATE..xls" style=Journal
options(sheet_interval = 'none'
sheet_name = 'MH3 SH Assignments'
autofit_height = 'yes'
suppress_bylines = 'yes'
gridlines = 'yes'
frozen_headers = '4'
absolute_column_width = '6, 7, 15, 15, 6, 8, 7, 7, 4, 4, 4, 4, 8, 8, 15, 8');
proc report data=mh13 nowd
style(REPORT)={cellpadding=5 background=#D0C7A8}
style(COLUMN)={font_face=Arial font_size=1 background=white}
style(HEADER)={font_face=Arial font_size=1 font_weight=bold foreground=black background=#EBE8DA};
column facility idno namel namef unitno cellno moveindt moveoutdt dsu asu imu bhu condition_code condition_type condition_description dd3need count;
define facility / group 'Inst';
define idno / 'SID';
define namel / 'Last Name';
define namef / 'First Name';
define unitno / 'Unit';
define cellno / 'Cell';
define moveindt / 'In Date';
define moveoutdt / 'Out Date';
define dsu / 'DSU';
define asu / 'ASU';
define imu / 'IMU';
define bhu / 'BHU';
define condition_code / 'BHS Code';
define condition_type / 'BHS Type';
define condition_description / 'BHS Description';
define dd3need / 'DD3';
define count / 'Count' noprint;
compute after facility / style=[font_face=Arial font_weight=bold font_size=1 foreground=black background=#DCD6BE];
line count.sum comma5. ' Inmate(s)';
line ' ';
endcomp;
compute after;
line count.sum comma5. ' Inmate(s)';
endcomp;
run;
ods tagsets.ExcelXP close;
ods listing;
Your tagset version is way out of date. I suggest you download and try the current version 1.130 which is still compatible with SAS 9.1.3:
Hi:
I'm just curious why you're not using the BREAK and RBREAK statements:
BREAK AFTER FACILITY/SUMMARIZE;
RBREAK AFTER/SUMMARIZE;
You want to summarize the COUNT column, but not show the COUNT column on the report???
cynthia
The code is a bit dated and created by a different person. The summarized total should appear but not the actual count column. I would own most error of this nature due to my lack of SAS knowledge. Sorry.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.