Help using Base SAS procedures

Proc Report

Reply
Super Contributor
Posts: 1,041

Proc Report

Hi,

I want to write Footnotes in the Proc Report

footnote1:Total number of discharges:22

footnote2Smiley Very Happyischarges with headaches:5 etc etc

I will know the count only after running the code for the datasets.for example 22 is got i the log after running a piece of code

5 is got after running a piece of code..

Instead of manually entering the counts in Footnotes How can I get SAS to write automatically?????(USING SYMPUT?????)

Thank you

Super User
Posts: 10,048

Re: Proc Report

Posted in reply to robertrao

Yes. you should use a macro variable.

SAS Super FREQ
Posts: 8,869

Re: Proc Report

Posted in reply to robertrao

Hi:

  You CAN use Macro variables, but you do not necessarily need CALL SYMPUT. SQL will do it too.

cynthia

proc sql;

  select distinct(sex), count(sex) into :cntgend1-:cntgend2, :tot1-:tot2

  from sashelp.class

  group by sex;

quit;

     

%put cntgend1=&cntgend1 tot1=&tot1;

%put cntgend2=&cntgend2 tot1=&tot2;

    

proc format;

  value $gfmt 'F' = 'Females'

              'M' = 'Males';

run;

    

ods html file='c:\temp\macvar.html';

    

proc report data=sashelp.class nowd;

title "The Report";

footnote "Total %sysfunc(putc(&cntgend1,$gfmt.)): &tot1";

footnote2 "Total %sysfunc(putc(&cntgend2,$gfmt.)): &tot2";

column age sex ('Average' height weight);

define age / group;

define sex / group;

define height / mean 'Height';

define weight / mean 'Weight';

run;

ods html close;

Ask a Question
Discussion stats
  • 2 replies
  • 202 views
  • 0 likes
  • 3 in conversation