05-14-2018 01:15 AM
I have a data about the Ufo and now I want to study whether the time will influence the sightings, I want to divide time in four parts and assumed that the Morning time is as 5:00-7:00, Daytime 7:00-17:00, Evening time 17:00-19:00 and night time is 19:00-5:00. How can I write a code about that? Should I use the if else statement?
05-14-2018 10:56 AM
It appears that your values are actually date times. Maybe. CSV, which the file isn't, is not a SAS data set.
Extract the Time value into a time variable. If the date time is a SAS date time value then the function TIMEPART will do that.
Then use a custom format similar to the following with that TIME only variable.
proc format; value mytime '19:00't < - '23:59't = 'Night' '00:00't - '05:00't = 'Night' '05:00't < - '07:00't = 'Morning' '07:00't < - '17:00't = 'Daytime' '17:00't < - '19:00't = 'Evening' ; run;
I suggest a format as you do not need to add additional variables but create a new format and use that if you decide you want 04:00 to 08:00 to be morning later, or perhaps reduce to 3 categories, or add. SAS will use
05-14-2018 11:26 AM
One of your classmates is having some difficulty as well.