Create variables and plots for UFOs

Reply
Occasional Learner
Posts: 1

Create variables and plots for UFOs

 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?

PROC Star
Posts: 1,269

Re: Create variables and plots for UFOs

Posted in reply to MichelleKorson

Tons of ways to do conditional processing. I would use the Select Statement in this case.

Super User
Posts: 13,508

Re: Create variables and plots for UFOs

Posted in reply to MichelleKorson

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

Super User
Posts: 23,681

Re: Create variables and plots for UFOs

Posted in reply to MichelleKorson
Ask a Question
Discussion stats
  • 3 replies
  • 105 views
  • 0 likes
  • 4 in conversation