Proc Report - Combine different datasets - detail and totals

Q1983 — Fri, 10 Jan 2020 19:37:49 GMT

data Exception;

format ex_date1 MMYYD.;

infile datalines;

input ex_date1 date9. Exception $ exc_cnt;

return;

datalines;

01Aug2019 Aged 1

01Aug2019 Current 11

01Sep2019 Expired 22

01Sep2019 Aged 1

01Aug2019 Aged 44

01Oct2019 Expired 4

;

data Exception_;

length Exception $30.;

set Exception;

exc_date=put(ex_date1,MMYYD.);

run;

data Actions;

length Action $30.;

format act_date1 MMYYD.;

infile datalines;

input act_date1 date9. Action $ act_cnt;

return;

datalines;

01Aug2019 Terminate 122

01Aug2019 Resch 1229

01Sep2019 Resch 850

01Sep2019 Research 2022

01Aug2019 Terminate 652

01Oct2019 Terminate 91

;

data Actions_;

set Actions;

act_date=put(act_date1,MMYYD.);

run;

proc report data=exception_ wrap style(column)={just=center};

title 'Final';

column Exception exc_date exc_cnt ;

define Exception / group style (column)=[cellwidth=100pt] "Exception Type";

define exc_date /across style(column)=[cellwidth=100pt]'';

define exc_cnt / sum "Exceptions" style(column)=[cellwidth=90pt];

rbreak after / summarize style (summary)= Header;

compute after;

Exception = 'Total Exceptions';

/*act_cnt = 'Total Actions';*/

endcomp;

run;

title;

proc report data=actions_ wrap style(column)={just=center};

column Action act_date act_cnt ;

define Action / group style (column)=[cellwidth=100pt] "Action Type";

define act_date /across style(column)=[cellwidth=100pt]'';

define act_cnt / sum "Actions" style(column)=[cellwidth=90pt];

rbreak after / summarize style (summary)= Header;

compute after;

Action = 'Total Actions';

/*act_cnt = 'Total Actions';*/

endcomp;

run;

Results

Exception Type	08-2019	09-2019	10-2019	Exceptions
Aged	2	1	0	46
Current	1	0	0	11
Expired	0	1	1	26
Total Exceptions	3	2	1	83

Action Type	08-2019	09-2019	10-2019	Actions
Resch	1	1	0	2079
Research	0	1	0	2022
Terminate	2	0	1	865
Total Actions	3	2	1	4966

I want to bring these two together and show the results as follows:

Exception Type	08-2019	09-2019	10-2019	Total
Aged	2	1	0	46
Current	1	0	0	11
Expired	0	1	1	26
Total Exceptions	3	2	1	83
Total Actions	3	2	1	4966

Exception Rate % %

Exception Rate the formula should be the total exception/total actions across

Re: Proc Report - Combine different datasets - detail and totals

PaigeMiller — Fri, 10 Jan 2020 20:09:17 GMT

I would do the calculations in PROC SUMMARY (one PROC SUMMARY for each data set), then combine the output data sets from PROC SUMMARY so that they match the requirements you have, then use PROC REPORT on this combined data set to make the final table.

topic Re: Proc Report - Combine different datasets - detail and totals in SAS Programming

Proc Report - Combine different datasets - detail and totals

Re: Proc Report - Combine different datasets - detail and totals