Create a table with specific formats using Proc Report

[nishant77goel]

A table is to be created is the attached format. It should contain a header like the one shown as 'Call Summary' and Count & % of calls as shown for the columns headers along with the quarter.

A BLANK grey line after the Column summary and some grayed rows where data will not be shown ever.

% and numeric values in same column.

Thanks for anyone's help in advance!

[PaigeMiller]

Most of us will not download or open Microsoft Office documents, as they are security threats. To show us the desired appearance of the output, you can provide a screen capture.

[nishant77goel]

[ballardw]

Do you expect the report procedure to calculate all of those fields?

Proc Report will expect a column to be of a single statistic and you are mixing counts, means and percentages in one column.

[nishant77goel]

Calculation will be done in prior steps, just the representation is to be done which will finally feed into PDF

[ed_sas_member]

Hi @nishant77goel 

Could you please share some sample data in regular datalines ?

[nishant77goel]

Hi,

data sample;
input _NAME_ $ _2019_Q1 _2019_Q2 _2019_Q3 _2019_Q4 _2020_Q1 _2020_Q1_1;
cards;
Total_Calls 0 0 0 0 0 1381
Patient_Member_Calls 0.3427 0.3667 0.3655 0.3923 0.3816 527
Provider_Calls 0.6055 0.5736 0.5599 0.5501 0.5902 815
Healthplan_Other_Calls 0.0518 0.0597 0.0745 0.0577 0.0282 39
Call_Center_Performance 0 0 0 0 0 0
Average_Speed_Answer_Seconds 0 0 0 0 0 15.52
Abandonment_Rate 0 0 0 0 0 0.73
Percent_Calls_Answered_30 0 0 0 0 0 0.8734
;

[ballardw]

I can do something similar with Proc Tabulate but that would be two tables, though close together. If you have all of the data pre-summarized then the data step Report Writing Interface allows you do place values in specific rows/columns. Be advised that with that much flexibility there is a bit more learning curve for some things than for the report procedures like Report or Tabulate because you have to provide rules for start/end of rows and the structure of your data set is going to be very important as to how you do that.

[nishant77goel]

slight space will be fine -

data sample;
input _NAME_ $ _2019_Q1 _2019_Q2 _2019_Q3 _2019_Q4 _2020_Q1 _2020_Q1_1;
cards;
Total_Calls 0 0 0 0 0 1381
Patient_Member_Calls 0.3427 0.3667 0.3655 0.3923 0.3816 527
Provider_Calls 0.6055 0.5736 0.5599 0.5501 0.5902 815
Healthplan_Other_Calls 0.0518 0.0597 0.0745 0.0577 0.0282 39
Call_Center_Performance 0 0 0 0 0 0
Average_Speed_Answer_Seconds 0 0 0 0 0 15.52
Abandonment_Rate 0 0 0 0 0 0.73
Percent_Calls_Answered_30 0 0 0 0 0 0.8734
;

[ballardw]

That is a very poorly structured example data for the type of table you are requesting.

Can you show us the un-summarized data?