topic Re: Create variables and plots for UFOs in SAS Programming

Create variables and plots for UFOs

MichelleKorson — Mon, 14 May 2018 05:15:30 GMT

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?

Re: Create variables and plots for UFOs

PeterClemmensen — Mon, 14 May 2018 06:19:50 GMT

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

Re: Create variables and plots for UFOs

ballardw — Mon, 14 May 2018 14:56:56 GMT

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

Re: Create variables and plots for UFOs

Reeza — Mon, 14 May 2018 15:26:16 GMT

https://communities.sas.com/t5/SAS-GRAPH-and-ODS-Graphics/SAS-UFO-sightings-plot/m-p/461889#M15924

One of your classmates is having some difficulty as well.