getting totals of individual variable in a column

[hondahawkrider]

9.3 Enterprise Guide

I have sas progam that inports log file info which looks like this - but it's thousands of lines..

Form, Status, InputDate, ProcessedDate
4    `R    `05/09/2017 11:21:37      `05/09/2017 11:22:15

4A   `R    `05/09/2017 11:21:32      `05/09/2017 11:22:18

13    `A    `05/09/2017 11:21:47      `05/09/2017 11:22:21

The sas program does a great job of caluclating the average time between the input date and received date (latency) for all the forms type based upon interval I use (say 15mins) via  a data statement (data t (keep=int_dt date hour latency type status) ;)

Any my data comes out like this ..

type	status	int_dt	latency	date	hour
13	A	09MAY17:11:21:00	25	20948	11
47	A	09MAY17:11:21:00	69	20948	11
28	A	09MAY17:11:21:00	65	20948	11
4	A	09MAY17:11:21:00	219	20948	11
4	A	09MAY17:11:21:15	20	20948	11
13	A	09MAY17:11:21:15	30	20948	11
4	A	09MAY17:11:21:15	29	20948	11
4A	A	09MAY17:11:21:15	28	20948	11
4A	R	09MAY17:11:21:15	28	20948	11
13	A	09MAY17:11:21:15	32	20948	11
4A	R	09MAY17:11:21:15	59	20948	11
4	A	09MAY17:11:21:15	20	20948	11

It's great and I love it - and it provides a great overall picture of everything, but now I need to drill down a bit... Basically I need to seperately split out the different form types 4, 4a, 13, etc, in addition to the overall picture and having a problem, thinking i could use a proc summary from t (name of data statement - see above) to split it by individual form types, but im not making much headway...... Any help is appreciated...

[Reeza]

PROC SUMMARY or MEANS is the correct procedure. 

Put you're group variable into the CLASS variable list. 

If it's not working, please post what you've tried. 

[ballardw]

What would your output look like for the example data? Your topic sas "getting totals" but you don't specify for which variable. Everything except Type and Status could be summed. Do you want a data set or a report type summation? If you want a data set what should the output look like as in what other variables should be present and what role, if any would Status,  Int_DT, date or hour play?

[hondahawkrider]

To answer the question of what i would think it would look like, it's be muliple proc summary for each type of form like for 13 type forms

type	status	int_dt	latency	date	hour
13	A	09MAY17:11:21:00	25	20948	11
13	A	09MAY17:11:21:15	30	20948	11
13	A	09MAY17:11:21:15	32	20948	11

and type 4

type	status	int_dt	latency	date	hour
4	A	09MAY17:11:21:00	219	20948	11
4	A	09MAY17:11:21:15	20	20948	11
4	A	09MAY17:11:21:15	29	20948	11
4	A	09MAY17:11:21:15	20	20948	11

and so on... it's just seperating out things by form type...

From there I can total things out individually by each form type as necessary...

Thanks in Advance