I want to get the number of transactions that happened in a particular hour of the day. I have a log database which has transaction details and time occurred. I run a frequency on the Hour to get number of transactions happened in an hour. If there is no txns happen in a particular hour I want it to be displayed as frequency 0. Is there any way customize PROC FREQ for this.
One way is to modify your table of transactions before your run PROC FREQ so that every hour of the day is represented by a dummy transaction, and there is a weight variable which takes on a value of 0 for those dummy transactions. Real transactions have a weight of 1.
Then in PROC FREQ, use the WEIGHT weightvar /ZEROS; command
This wont remove the title Table of X by Y right?. I read in some website that there is an option NOTITLE to remove both the titles and its not working for me. Also I read that this option was available from sas 8.2 onwards and they removed it from SAS 9 onwards. Any body have any idea on this?