proc report data=table nowd headline headskip missing split="*" formchar="|----|+|---+=|-/\<>*" style=monospace
out=&ov_out.(where=(_break_=""))
style(report)=[outputwidth=101%]
style(header)=[just=l asis=on ]
style(column)=[just=l asis=on ];
columns pg aperiod visitnum paramn roword cat0 stat_c1-stat_c4;
define pg / order order=internal noprint;
define aperiod / order order=internal noprint;
define visitnum / order order=internal noprint;
define paramn / order order=internal noprint;
define roword / order order=internal noprint;
define cat0 / "Period* Visit* Measurement/Lab Test (Units)" flow style(column)=[just=left cellwidth = 15.1%];
define stat_c1 / "* TRT A* N=&n1" flow style(column)=[just=left cellwidth = 6.1%];
define stat_c2 / "* TRT B* N=&n2" flow style(column)=[just=left cellwidth = 6.1%];
define stat_c3 / "* TRT C* N=&n3" flow style(column)=[just=left cellwidth = 6.1%];
define stat_c4 / "* TOTAL* N=&n4" flow style(column)=[just=left cellwidth = 6.1%];
break after pg / page;
compute before / style={just=l}; line "&headline"; endcomp;
compute before _page_/ style={just=l}; line "&headline"; line ""; endcomp;
compute after _page_ / style={just=l borderbottomcolor=white}; line "&headline"; endcomp;
compute after paramn / style={just=l borderbottomcolor=white}; line ""; endcomp;
compute before pg / style={just=l borderbottomcolor=white}; line ""; endcomp;
run;
Hi, I need lines under column headers and at the bottom of the table. The lines are displaying but not properly. Line spills onto the next line. I am using a macro variable and compute blocks to get the lines. Macro variable is %let headline = %sysfunc(repeat('_',&ls-2)). &ls is another macro variable for line size and is currently set at 133 from what I can tell. If anyone has a better way to get the lines, please let me know. I already have headline and headskip options on proc report and a paging variable called pg. I have break after pg / page.
I would like the yellow to go away. Same is happening for line under the table.
Okay, I think I fixed it by using these macro variables instead of &headline.
%let bb=\brdrb\brdrs\brdrw10;
%let tb=\brdrt\brdrs\brdrw10;
Okay, I think I fixed it by using these macro variables instead of &headline.
%let bb=\brdrb\brdrs\brdrw10;
%let tb=\brdrt\brdrs\brdrw10;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.