topic PUT a value in Column header for PROC REPORT in SAS Programming

PUT a value in Column header for PROC REPORT

saslove — Thu, 01 Nov 2018 23:38:15 GMT

Is there a way to bring the value from a PROC FREQ output dataset into a PROC REPORT header?

For ex:

proc freq data=data;
tables cohort/out=cohortct (drop=percent rename=count=cohortct);
run;

data cohortct;
set cohortct;
cohortct2=strip(cohort||' (N='||(strip(cohortct)||')'));
put cohortct2;
run;

I need to display COHORTCT2 in a column header in PROC REPORT.

This is the value of COHORTCT2

1A (N=4)
1B (N=7)

proc report data=table1 split="|" ;
column cohort number1 ;
define cohort/display center style(column)={width=1in} 'Cohort I need the numbers for COHORTCT here';
define number1 /display right style(column)={width=.5in} 'Subjects experiencing Grade 1';
run;

How can this be done?

Re: PUT a value in Column header for PROC REPORT

ChrisNZ — Fri, 02 Nov 2018 02:03:44 GMT

How about

data COHORTCT;
  set COHORTCT;
  COHORTCT2=strip(COHORT||' (N='||(strip(COHORTCT)||')'));
  call symputx ('cohortct2',COHORTCT2);
run;
 
proc report data=TABLE1 split="|" ;
  column COHORT NUMBER1 ;
  define COHORT/display center style(column)={width= 1in} "Cohort &cohortct2";
  define NUMBER1/display right style(column)={width=.5in} 'Subjects experiencing Grade 1';
run;

Re: PUT a value in Column header for PROC REPORT

saslove — Fri, 02 Nov 2018 15:57:04 GMT

It only displays &cohortct2 on the column header. It doesn't display the
numbers I want.

Re: PUT a value in Column header for PROC REPORT

ChrisNZ — Sun, 04 Nov 2018 21:47:50 GMT

Did you copy the code as is? Including the double quotes?

Re: PUT a value in Column header for PROC REPORT

saslove — Mon, 05 Nov 2018 17:34:06 GMT

You are right. The double quote did work - but the problem is it only keeps the second row.

I need

1A (N=4)
1B (N=7)

on the column header. But it only shows the second row, 1B (N=7).

Do you know why?

Re: PUT a value in Column header for PROC REPORT

ChrisNZ — Mon, 05 Nov 2018 20:09:12 GMT

it only keeps the second row. Do you know why?

Because that's what you programmed.

I reckon the easiest is for you to create two macro variables

if _N_=1 then call symput...

if _N_=2 then call symput...

Re: PUT a value in Column header for PROC REPORT

saslove — Tue, 06 Nov 2018 02:13:04 GMT

Ok yes I created where statements and it worked perfectly. Thanks so much for your response.