Hi,
Right now I create a data file in SAS, and I'm trying to show some summaries of the data (from different perspectives) so people can quickly determine if the data set is flawed in some way. Here are two examples of the summaries I create:
proc sql;
create table endsql1 as
select issyear,issmonth,aveissmonth,sum(count) as PolicyCount,sum(units) as Units,sum(amtinfrc) as AmountInforce,sum(statres) as StatReserve
from endmerge3
group by issyear,issmonth,aveissmonth;
quit;
proc export data = endsql1
dbms = excel2000
outfile = "J:\Val\Japan\Ord\20&crntqtr.\Prodfiles\SAScode\Summaries\Ord\&inforcefilename.&valqtr.END.xls"
replace;
sheet = 'IssueDate';
run;
proc sql;
create table endsql2 as
select modelage,issage,sum(count) as PolicyCount,sum(units) as Units,sum(amtinfrc) as AmountInforce,sum(statres) as StatReserve
from endmerge3
group by modelage,issage;
quit;
proc export data = endsql2
dbms = excel2000
outfile = "J:\Val\Japan\Ord\20&crntqtr.\Prodfiles\SAScode\Summaries\Ord\&inforcefilename.&valqtr.END.xls"
replace;
sheet = 'IssueAge';
run;
I would like to include, on another tab of this spreadsheet, the name & location of the program that produced it. Additionally, I would like these summaries to display totals of each data field on the last row. Does anyone know of a way to code this into SAS? I have searched for quite some time with no luck. Thanks in advance!
-Ken