topic Re: Proc print By+ID-column titleswill appear only once in SAS Programming

Proc print By+ID-column titleswill appear only once

Ronein — Wed, 19 Oct 2022 21:04:53 GMT

Hello
I am using proc print with ID+By options.
What is the way that the column titles will appear only one time?

 
 
Data have;
Input ID JobCode $ Gender $ Salary;
cards;
111 FA1 F 23177
222 FA1 F 22454
333 FA1 M 22268
444 FA2 F 28888
555 FA2 F 27787
666 FA2 M 28572
777 FA3 F 32886
888 FA3 F 33419
999 FA3 M 32217
;
Run;

proc print data=have;
id jobcode;
by jobcode;
var gender salary;
run;

Re: Proc print By+ID-column titleswill appear only once

ballardw — Wed, 19 Oct 2022 20:45:02 GMT

Please look at that data step and check for completeness. There is no way you got that output from that data set.

@Ronein wrote:

Hello

I am using proc print with ID+By options.

What is the way that the column titles will appear only one time?
Data have;
Input  CustID  JobCode $   Gender $  Salary;
cards;
111
222
333
444
555
666
777
888
999
;
Run;

proc print data=have;
 id jobcode;
 by jobcode;
 var gender salary;
run;

Re: Proc print By+ID-column titleswill appear only once

Ronein — Wed, 19 Oct 2022 21:06:37 GMT

There was missing data in the data step and I fixed it.
The question is how to create the report by group with one row of columns titles .
Please note that in this report there is no summary calculation

Re: Proc print By+ID-column titleswill appear only once

Tom — Wed, 19 Oct 2022 21:19:44 GMT

What type of output are you generating?

Your code runs fine when I run it.

Normal output

Job
Code    Gender    Salary

FA1       F        23177
          F        22454
          M        22268


FA2       F        28888
          F        27787
          M        28572


FA3       F        32886
          F        33419
          M        32217

HTML output

Re: Proc print By+ID-column titleswill appear only once

Ronein — Wed, 19 Oct 2022 21:44:30 GMT

Please.pook at the attached photo where you can see the wanted report. As you can see in the wanted report I want to have one line of columns headers .

Re: Proc print By+ID-column titleswill appear only once

Ksharp — Thu, 20 Oct 2022 11:45:32 GMT

Data have;
Input ID JobCode $ Gender $ Salary;
cards;
111 FA1 F 23177
222 FA1 F 22454
333 FA1 M 22268
444 FA2 F 28888
555 FA2 F 27787
666 FA2 M 28572
777 FA3 F 32886
888 FA3 F 33419
999 FA3 M 32217
;
Run;

proc report data=have nowd;
columns JobCode  Gender  Salary;
define  JobCode/order;
define  Gender/display;
run;