SAS function to select only particular time of the day

deleted_user — Fri, 19 Feb 2010 17:40:48 GMT

I have sales data and tiem of sale given .The input are :
TransactionID $1-8
DateofSale $9-18
TimeofSale $19-26
LaptopModel $27-32
UnitsSold 33-35
Warranty 36

I want to find the proprtion of the transactions that qualify for the delivery before 3 p.m. only of each day and all dates are in the form : 08:49:26 , for e.g.

What SAS functions should I use and what procedure to follow.

kind regards ,
markc

Re: SAS function to select only particular time of the day

sbb — Fri, 19 Feb 2010 17:52:59 GMT

I would expect by now that you have a SAS numeric (using TIMEw. format) variable for your character field TimeofSale. It's unclear what determines "delivery before 3 p. m." -- you would need to explain / reveal that information.

It is possible to use a SAS assignment statement to test for a SAS time constant, such as "15:00:00"T (arbitrary example time-of-day) -- then analyze your data by using SAS procedures SUMMARY, MEANS, possibly.

Furthermore, SAS procedures have been suggested, in general, for your prior posts - yet we know nothing about how much use of any of the procedures you have actually had with some success.

I strongly encourage you to take a step back, determine how much time you wish to invest in learning the SAS Base system (to get started), then consider beginning here:

http://support.sas.com/training/elearn/

And, I can't emphasize enough that there are technical resources at your disposal with the SAS support http://support.sas.com/ website, for consideration.

Best of luck with your SAS learning and programming endeavors.....

Scott Barry
SBBWorks, Inc.

topic SAS function to select only particular time of the day in SAS Procedures

SAS function to select only particular time of the day

Re: SAS function to select only particular time of the day