Hi,
I want to write Footnotes in the Proc Report
footnote1:Total number of discharges:22
footnote2:Discharges 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
Yes. you should use a macro variable.
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.