topic Re: Create a table with specific formats using Proc Report in SAS Programming

Create a table with specific formats using Proc Report

nishant77goel — Tue, 26 May 2020 11:41:13 GMT

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!

Re: Create a table with specific formats using Proc Report

PaigeMiller — Tue, 26 May 2020 11:43:59 GMT

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.

Re: Create a table with specific formats using Proc Report

nishant77goel — Tue, 26 May 2020 11:52:39 GMT

Re: Create a table with specific formats using Proc Report

ballardw — Tue, 26 May 2020 13:36:22 GMT

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.

Re: Create a table with specific formats using Proc Report

nishant77goel — Tue, 26 May 2020 13:39:06 GMT

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

Re: Create a table with specific formats using Proc Report

ed_sas_member — Tue, 26 May 2020 15:12:58 GMT

Hi @nishant77goel

Could you please share some sample data in regular datalines ?

Re: Create a table with specific formats using Proc Report

ballardw — Tue, 26 May 2020 16:48:46 GMT

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.

Re: Create a table with specific formats using Proc Report

nishant77goel — Tue, 26 May 2020 17:52:12 GMT

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
;

Re: Create a table with specific formats using Proc Report

nishant77goel — Tue, 26 May 2020 17:53:21 GMT

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
;

Re: Create a table with specific formats using Proc Report

ballardw — Tue, 26 May 2020 19:03:31 GMT

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

Can you show us the un-summarized data?