Hi All,
I keep getting the following in my tables in sas (in the autofilter):
http://i.imgur.com/r5tjKcr.png
I have a total at the end of the table which is causing this - any way to remove/hide it?
could you provide a snippet of your code.
I am assuming this is a proc report?
Actually, I am using proc print:
proc print data=testdata noobs label;
var Org Unit N;
where Org="Org1";
sum N;
label N="Number of x";
label Org="Organization";
label unit="Unit";
run
What do you mean in autofilter? Are you using EG?
I am using tagsets, so the ables have an autofilter at the top:
style=sasweb
options(toc_background="white"
toc_expand="yes"
toc_print="yes"
autofilter="yes"
filter_cols="1,2,3"
What happens when you run this code:
ods tagsets.excelxp file = "\\your_path\to_test.xls" style = sasweb
options(autofilter="yes" );
proc print data=sashelp.class noobs label;
var name height;
where age=12;
sum age;
label age="Age";
run;
ods tagsets.excelxp close;
You note I removed the toc_...options because SAS said unrecognized option...
Does this work?
PS: change the path where the file is saved
Nop, same " " shows up in the filter. :smileycry:
What version of Excel are you using?
Post your full code and log or a smaller sample if it generates the problem.
I am not using excel - the output is done in HTML file.
You need to post your full code and log of what you're doing. We're really just trying to guess without it and its a waste of time for us and yourself.
Hi Vomer,
Would you please post the code?
Thanks.
Anca.
Sure:
ods tagsets.tableeditor file="file1.html"
path="PATH\HERE" (url=none)
style=styles.button
options(toc_background="white"
toc_expand="yes"
toc_print="yes"
autofilter="yes"
filter_cols="1,2,3"
AUTOFILTER_ENDCOL="3"
frozen_headers="yes"
pageheight="400"
autofilter_width="15em"
);
title1 'Number of Clients';
proc print data=testdata noobs label;
var Org Unit N;
where Org="Org1";
sum N;
label N="Number of x";
label Org="Organization";
label unit="Unit";
run;
ods tagsets.tableeditor close;
So, in the SAS Output wahtever you are trying to print will look (more or less) like this:
Age | Height |
12 | 57.3 |
12 | 59.8 |
12 | 59.0 |
12 | 56.3 |
12 | 64.8 |
====== | |
297.2 |
The 'problem' is the line ===== which translate to a non blank space (nbsp) (I may over-reaching here)...but when you try to filter your data, you also have this option...the ====
So, I need to read/google more to figure out how to 'restrict' it from showing in your html...
more later.
Hi Anca, Yes I think it is that extra line that is causing the "space" to appear. Hope you can find a solution - I could not find anything so far
Hi,
would you please try this addition to your existing code:
ods tagsets.tableeditor file="file1.html" event = cell_is_empty |
path="\\yourPath..." (url=none)
style=styles.button
options(toc_background="white"
....rest of code....
I think it may work!
Actually it will only work if you are summing over all the variables you are printing...
Message was edited by: Anca Tilea
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.