BookmarkSubscribeRSS Feed
nishant77goel
Obsidian | Level 7

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!

9 REPLIES 9
PaigeMiller
Diamond | Level 26

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.

--
Paige Miller
ballardw
Super User

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
Obsidian | Level 7
Calculation will be done in prior steps, just the representation is to be done which will finally feed into PDF
ed_sas_member
Meteorite | Level 14

Hi @nishant77goel 

 

Could you please share some sample data in regular datalines ?

nishant77goel
Obsidian | Level 7
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
Super User

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
Obsidian | Level 7
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
Super User


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

Can you show us the un-summarized data?

 

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 9 replies
  • 1138 views
  • 0 likes
  • 4 in conversation