topic Re: Draw a sold black line after the first row in proc report in SAS Programming

Draw a sold black line after the first row in proc report

KrishnaChandra — Thu, 20 Nov 2014 13:56:10 GMT

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

Re: Draw a sold black line after the first row in proc report

RW9 — Thu, 20 Nov 2014 14:20:19 GMT

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 "-----".

Re: Draw a sold black line after the first row in proc report

KrishnaChandra — Thu, 20 Nov 2014 14:29:17 GMT

Hai

I need to draw the solid line only after the first row(n%rows)... Do you help me to solve this crises

Re: Draw a sold black line after the first row in proc report

RW9 — Thu, 20 Nov 2014 14:32:45 GMT

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 */

Re: Draw a sold black line after the first row in proc report

KrishnaChandra — Thu, 20 Nov 2014 14:38:35 GMT

But the n% row is not a header part.

Re: Draw a sold black line after the first row in proc report

RW9 — Thu, 20 Nov 2014 14:44:23 GMT

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.

Re: Draw a sold black line after the first row in proc report

data_null__ — Thu, 20 Nov 2014 14:52:30 GMT

n (%) is redundant put it in the title

Table: 14-06-zz-x Summary n(%) of Adverse Events .....

Re: Draw a sold black line after the first row in proc report

RW9 — Thu, 20 Nov 2014 14:54:27 GMT

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.

Re: Draw a sold black line after the first row in proc report

data_null__ — Thu, 20 Nov 2014 15:05:29 GMT

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.

Re: Draw a sold black line after the first row in proc report

KrishnaChandra — Thu, 20 Nov 2014 15:06:15 GMT

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??

Re: Draw a sold black line after the first row in proc report

data_null__ — Thu, 20 Nov 2014 15:12:28 GMT

Make an WORKING example program that shows what you have so far.

Re: Draw a sold black line after the first row in proc report

KrishnaChandra — Thu, 20 Nov 2014 15:24:45 GMT

This is my code spinet for report

Re: Draw a sold black line after the first row in proc report

data_null__ — Thu, 20 Nov 2014 15:43:26 GMT

By WORKING I mean an example with data (or SASHELP data) that I can copy and paste and run using "my" SAS.

Re: Draw a sold black line after the first row in proc report

KrishnaChandra — Thu, 20 Nov 2014 15:48:55 GMT

ok thanx

Re: Draw a sold black line after the first row in proc report

Cynthia_sas — Thu, 20 Nov 2014 16:12:50 GMT

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

Re: Draw a sold black line after the first row in proc report

KrishnaChandra — Thu, 20 Nov 2014 16:41:41 GMT

Hai Cynthia am looking for only RTF

Re: Draw a sold black line after the first row in proc report

KrishnaChandra — Thu, 20 Nov 2014 17:22:39 GMT

Hai Is there any possible way to draw the black solid line for the top of all n(%). I need a row separation

Re: Draw a sold black line after the first row in proc report

Cynthia_sas — Thu, 20 Nov 2014 22:27:12 GMT

Hi:

It looks like you are NOT using the default fonts for RTF and I do NOT see where you are changing the fonts to Courier or some other serif font. How did you take this screen shot? Was this report produced with the code you posted. You said that you wanted RTF but you do NOT show all your code. What does your ODS RTF invocation look like? What style template or STYLE= option do you use? Do you use a custom style template? Did you write the style template? If not, and you ARE using a style template, then the person who wrote the style template should be able to help you get the formatting your want. Have you tried the Journal style with RTF -- that was designed for this type of demographic report or Adverse Even report. For example, a slight modification of the program I posted produces this output, that shows a line underneath the headers, just using the JOURNAL style.

cynthia