topic Re: Proc print by ID in SAS Programming

Proc print by ID

Ronein — Wed, 31 Jul 2019 08:46:43 GMT

Hello

In this example I create multiple prints (by group)

I have 1 questions:

1-I want to have empty line between the print outputs

When I do copy and paste it into excel the prints are all connected and I want to have empty line between outputs

2-I want to color value under PCT column in last row of each print:

IF value>39% then it will have red background color.

IF value<=39% then it will have green background color.

data aaa;
input ID  group $ Y;
cards;
1 a 10
2 a 20
3 a 30
4 a 40
5 b 50
6 b 60
7 b 70
8 c 80
9 c 90
10 c 100
;
run;
data bbb;
   set aaa; 
   by group;
   if first.group then total=0;
   total + y;
   PCT=y/total;
   format PCT percent9.2;
run;
title;
proc print data=bbb  noobs;
by group;
id group;
run;

Re: Proc print by ID

Shmuel — Wed, 31 Jul 2019 09:52:06 GMT

You can add FOOTNOTEs in order to have space between IDs.

Re: Proc print by ID

Ronein — Wed, 31 Jul 2019 09:55:23 GMT

I tried to use footnote but I don't see any difference

title;
proc print data=bbb  noobs;
by group;
id group;
footnote;
run;

Re: Proc print by ID

andreas_lds — Wed, 31 Jul 2019 11:37:53 GMT

You will have to change the template used to increase the space between tables. Depending on the output-format you are using, using CSS can help - i never did it, so this is just how i would try to solve the problem.

There are so many papers about how to change background color of cells and rows, i am sure you can find examples.

EDIT: The title; statement resets all title-statements executed before. The footnote; has the same effect on footnotes.

Re: Proc print by ID

Shmuel — Wed, 31 Jul 2019 11:57:11 GMT

Try

title1 'My Title';
proc print data=bbb  noobs;
by group;
id group;
run;

footnote1 ' E - N - D ';
footnote2 '               ';

Re: Proc print by ID

Ronein — Sun, 04 Aug 2019 06:08:37 GMT

Thank you so much.

I see that for example IF I want to have 3 lines of space between the printed tables then I need to have 3 footnote statements.

for example:

footnote;
footnote1 '               ';
footnote2 '               ';
footnote3 '               ';
title;
title1 'XXXXXX';
proc print data=sashelp.cars(where=(Type="SUV")) noobs;run;

title;
title1 'YYYY';
proc print data=sashelp.cars(where=(Type="SUV")) noobs;run;