hai all Please do help me?
I would like to know how to draw a solid black line after the first row in proc report?? :smileyplain:
Thanks
Krishna
Maybe provide an example of where you want the output to look like. Does under the first row mean, under column headers, before first row of data, after first row of data, do you want it on all pages, or only the first. Etc. You could for instance if its after the first row of data only on page 1, have a variable in your data with Y in the first record, set it as noprint in your proc report. Then have a compute after that variable, line "-----".
Hai
I need to draw the solid line only after the first row(n%rows)... Do you help me to solve this crises
That's to do with your styles. You can update your style template, or in your report specify it:
proc report data = YOUR_DATA nowd split="~" style(header)=[borderbottomwidth=1 borderbottomcolor=black]; /* Change the 1 to whatever width you like */
But the n% row is not a header part.
That depends on your data, and how you setup your headers. I assume you have something like:
proc report ...;
columns COL1 ("ABI-007 + Gemcitabine~{newline}(N=22)" COL2 COL3 ...;
Post your report code if not.
n (%) is redundant put it in the title
Table: 14-06-zz-x Summary n(%) of Adverse Events .....
Do you know what, I actually had to look at that output several times before I even noticed the row of n (%)'s. Concur with data _null_; it should not be there.
Of course I'm sure the consumers of the report will insist it be done that way. I think the OP can have "his" cake eat it too if the line of "n (%)" is made part of the data.
But i need the n% as a separated row .It should be styled with solid black color for top and bottom.I already got the top solid black line and looking for the Bottom??
Make an WORKING example program that shows what you have so far.
This is my code spinet for report
By WORKING I mean an example with data (or SASHELP data) that I can copy and paste and run using "my" SAS.
ok thanx
Hi: To add a comment to DATA_NULL_'s suggestion, please post ALL your code. Most SAS sessions either produce HTML output or EG default output -- let us know your destination requirements by showing your ODS statements. For example, is this output you want RTF, PDF, HTML, or some other destination? That is crucial information when you are talking about interior table lines. For example, refer to this previous forum posting and if you run the code, note how the different destinations interpret the border controls differently. https://communities.sas.com/message/238315#238315 (see posted code from Nov 18th).
cynthia
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.