Hi, I have a (perhaps) rather simple question. I am working on real time data that looks like this: Sample Location Date Time Concentration X Concentration Y Office 08/09/2009 1:00:00 2 7 Office 08/09/2009 1:00:10 5 5 Office 08/09/2009 1:00:30 5 6 There are several sampling locations, dates, and times. I would like to obtain average concentrations in these different areas, different dates (day of the week), and different times (morning, noon, evening, overnight). I understand how to do this for sample location using proc means, but I get stumped when I need to do this for time and date variables. I originally used proc means for different times of day but SAS did not understand this: My questions are as follows: 1. Do I need to transform my 'Time' variable, because SAS does not seem to recognize this as time? If so, how do I do this. I was thinking of making a dummy variable for morning, noon, evening, overnight but SAS does not seem to recognize the time as it is in my database. 2. The same question but for Date. Are there any transformations that need to be made? Thank-You.
... View more