- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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