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?

 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 1862 views
  • 0 likes
  • 4 in conversation