Search the site...
SASCRUNCH TRAINING
Home
Member's Area
How to Start
SAS Interface
Creating a Data Set
Practical SAS Training Course
SAS Certified Specialist Training Program
Proc SQL Course
Introduction to Time Series Analysis
SAS Project Training Course
Full Training / Membership
Sign up
About us
Contact us
Home
Member's Area
How to Start
SAS Interface
Creating a Data Set
Practical SAS Training Course
SAS Certified Specialist Training Program
Proc SQL Course
Introduction to Time Series Analysis
SAS Project Training Course
Full Training / Membership
Sign up
About us
Contact us
Sentry Page Protection
Please Wait...
Exercise (1-5)
Copy and run the code from the yellow box below:
data order; input order $ date : mmddyy10. time : time8. product : $30.; format date mmddyy10. time time8.; datalines; ORD001 06/09/2019 9:09:51 Caesar ORD001 06/09/2019 9:09:51 Sausage ORD002 06/09/2019 9:16:06 Latte ORD002 06/09/2019 9:16:06 Latte ORD003 06/09/2019 9:23:53 Caesar ORD003 06/09/2019 9:32:15 Caesar ORD003 06/09/2019 9:32:15 Sausage ORD004 06/09/2019 9:37:33 Sausage ORD004 06/09/2019 9:43:22 Ham ORD004 06/09/2019 9:43:22 Caesar ORD005 06/09/2019 9:52:17 Ham ORD005 06/09/2019 10:00:09 Latte ORD005 06/09/2019 10:00:09 Caesar ORD006 06/09/2019 10:03:01 Cappuccino ORD006 06/09/2019 10:03:01 Caesar ORD006 06/09/2019 10:10:07 Sausage ORD006 06/09/2019 10:10:07 Latte ORD007 06/09/2019 10:13:17 Sausage ORD007 06/09/2019 10:13:17 Cappuccino ORD008 06/09/2019 10:17:52 Sausage ORD008 06/09/2019 10:17:52 Caesar ORD009 06/09/2019 10:22:40 Cappuccino ORD009 06/09/2019 10:22:40 Sausage ORD010 06/09/2019 10:29:02 Sausage ORD011 06/09/2019 10:34:53 Cappuccino ORD011 06/09/2019 10:34:53 Ham ORD012 06/09/2019 10:42:33 Sausage ORD012 06/09/2019 10:46:01 Cappuccino ORD012 06/09/2019 10:46:01 Latte ORD013 06/09/2019 10:55:28 Caesar ORD013 06/09/2019 10:55:28 Sausage ORD013 06/09/2019 10:59:21 Cappuccino ORD013 06/09/2019 10:59:21 Caesar ORD014 06/09/2019 11:05:47 Caesar ORD014 06/09/2019 11:05:47 Caesar ORD014 06/09/2019 11:14:34 Latte ORD014 06/09/2019 11:14:34 Caesar ORD015 06/09/2019 11:20:24 Latte ORD015 06/09/2019 11:20:24 Sausage ORD016 06/09/2019 11:28:24 Latte ORD017 06/09/2019 11:30:32 Ham ORD017 06/09/2019 11:33:01 Latte ORD018 06/09/2019 11:36:48 Caesar ORD018 06/09/2019 11:42:23 Ham ORD018 06/09/2019 11:42:23 Cappuccino ORD019 06/09/2019 11:44:53 Sausage ORD019 06/09/2019 11:44:53 Latte ORD020 06/09/2019 11:51:44 Caesar ORD020 06/09/2019 11:51:44 Sausage ORD020 06/09/2019 11:55:55 Latte ORD021 06/09/2019 11:59:16 Cappuccino ORD021 06/09/2019 11:59:16 Cappuccino ORD021 06/09/2019 12:03:25 Ham ORD022 06/09/2019 12:07:53 Ham ORD023 06/09/2019 12:13:39 Latte ORD023 06/09/2019 12:18:48 Cappuccino ORD024 06/09/2019 12:24:37 Cappuccino ORD025 06/09/2019 12:28:16 Sausage ORD025 06/09/2019 12:28:16 Sausage ORD026 06/09/2019 12:33:19 Caesar ORD027 06/09/2019 12:38:42 Caesar ORD028 06/09/2019 12:44:01 Sausage ORD029 06/09/2019 12:53:21 Cappuccino ORD030 06/09/2019 12:59:12 Latte ORD031 06/09/2019 13:04:30 Ham ORD032 06/09/2019 13:10:36 Caesar ORD032 06/09/2019 13:10:36 Caesar ORD033 06/09/2019 13:14:36 Cappuccino ORD033 06/09/2019 13:18:38 Ham ORD034 06/09/2019 13:28:37 Caesar ORD034 06/09/2019 13:28:37 Cappuccino ORD035 06/09/2019 13:37:42 Latte ORD036 06/09/2019 13:45:35 Ham ORD037 06/09/2019 13:53:33 Ham ORD037 06/09/2019 13:53:33 Ham ORD037 06/09/2019 13:59:46 Cappuccino ORD038 06/09/2019 14:06:05 Sausage ORD038 06/09/2019 14:06:05 Ham ORD038 06/09/2019 14:10:43 Latte ORD038 06/09/2019 14:10:43 Latte ORD039 06/09/2019 14:13:51 Cappuccino ORD039 06/09/2019 14:17:20 Sausage ORD040 06/09/2019 14:26:43 Latte ORD040 06/09/2019 14:31:43 Caesar ORD040 06/09/2019 14:31:43 Sausage ORD041 06/09/2019 14:38:40 Latte ORD042 06/09/2019 14:44:53 Latte ORD042 06/09/2019 14:44:53 Cappuccino ORD043 06/09/2019 14:48:36 Sausage ORD043 06/09/2019 14:50:24 Latte ORD043 06/09/2019 14:50:24 Ham ORD044 06/09/2019 14:55:17 Cappuccino ORD044 06/09/2019 14:55:17 Caesar ORD044 06/09/2019 15:01:17 Cappuccino ORD045 06/09/2019 15:05:43 Cappuccino ORD045 06/09/2019 15:05:43 Caesar ORD045 06/09/2019 15:10:14 Ham ORD045 06/09/2019 15:10:14 Latte ORD046 06/09/2019 15:13:57 Latte ORD046 06/09/2019 15:13:57 Sausage ORD046 06/09/2019 15:17:37 Cappuccino ORD047 06/09/2019 15:25:52 Latte ORD047 06/09/2019 15:25:52 Latte ORD047 06/09/2019 15:30:24 Latte ORD048 06/09/2019 15:39:42 Caesar ORD048 06/09/2019 15:39:42 Sausage ORD048 06/09/2019 15:44:16 Cappuccino ORD049 06/09/2019 15:53:59 Ham ORD050 06/09/2019 15:55:49 Ham ; run;
The ORDER data set contains a list of orders on June 9, 2019.
What is the best-selling product before 11 am?
Next