topic Re: Code for time and day of the week ? in SAS Programming

Code for time and day of the week ?

SASforHealth — Fri, 06 Mar 2020 12:04:09 GMT

Hi all,

I have a variable that have date and time. Is there a code to identify the day of the week and time of the day from this unformatted variable? Thanks in advance!

Re: Code for time and day of the week ?

SASforHealth — Fri, 06 Mar 2020 12:04:44 GMT

Re: Code for time and day of the week ?

PeterClemmensen — Fri, 06 Mar 2020 12:05:51 GMT

Is the variable chracter or an actual SAS Datetime value?

Re: Code for time and day of the week ?

ed_sas_member — Fri, 06 Mar 2020 12:28:15 GMT

Hi @SASforHealth

Assuming the variable is a SAS datetime you can do:

data test;
format dt datetime18. time time10.;
dt = "06MAR2020 12:36"dt;
day = weekday(datepart(dt));  
time = timepart(dt);
run;

Assuming it is a character string:

data test;
format. time time10.;
dt = input("06MAR2020 12:36", datetime18.);
day = weekday(datepart(dt));
time = timepart(dt);
run;

Re: Code for time and day of the week ?

ballardw — Fri, 06 Mar 2020 16:19:50 GMT

@SASforHealth wrote:
Hi all,

I have a variable that have date and time. Is there a code to identify the day of the week and time of the day from this unformatted variable? Thanks in advance!

Please help us help you by showing what you have and whether that is a SAS character variable or not.

Re: Code for time and day of the week ?

SASforHealth — Tue, 10 Mar 2020 14:16:19 GMT

it is a character value ($32,000.00 )

Re: Code for time and day of the week ?

andreas_lds — Tue, 10 Mar 2020 14:48:06 GMT

@SASforHealth wrote:

it is a character value ($32,000.00 )

Then fix that issue first and transform it to be a more useful sas-datetime-variable.

Re: Code for time and day of the week ?

SASforHealth — Tue, 10 Mar 2020 15:42:51 GMT

my current variable is Incident_DateTime with a character value of $32000 but the date represents a true sas date and time (ex. value=43323.24039351852). I have attempted both of your codes but I am not having success. I am stuck and not sure how to switch it to a sas date time variable. In your example could you please use my variable name to reduce confusion. thanks so much!

Re: Code for time and day of the week ?

SASforHealth — Tue, 10 Mar 2020 15:34:07 GMT

how?

Re: Code for time and day of the week ?

SASforHealth — Tue, 10 Mar 2020 15:55:37 GMT

I used code:

Date2 =DATEPART(Incident_DateTime);
Time= TIMEPART (Incident_DateTime);

now my time is correct and my date is falsely "01JAN1960" any suggestions? My true date values are present date

Re: Code for time and day of the week ?

Tom — Tue, 10 Mar 2020 15:55:55 GMT

@SASforHealth wrote:

my current variable is Incident_DateTime with a character value of $32000 but the date represents a true sas date and time (ex. value=43323.24039351852). I have attempted both of your codes but I am not having success. I am stuck and not sure how to switch it to a sas date time variable. In your example could you please use my variable name to reduce confusion. thanks so much!

That helps. I was wondering how you were planning to convert a value like '$32000' in a date time.

Those numbers do NOT look like date time.

Please explain what date and time the value 43,323.24039351852 is supposed to be?

Is that supposed to be number of days and fractions of a day?

What date does the number 43,323 represent?

Re: Code for time and day of the week ?

SASforHealth — Tue, 10 Mar 2020 16:01:20 GMT

sometime in the past 3 years 2017-2020, i am not sure of the date as this is my only date time variable.

Re: Code for time and day of the week ?

Tom — Tue, 10 Mar 2020 16:02:05 GMT

Perhaps it is counting days since 1900 instead of since 1960 like SAS does?

1612  data test;
1613    dt1=dhms(43323.24039351852,0,0,0);
1614    dt2=dt1+'01Jan1900:00:00'dt;
1615
1616
1617    put (_all_) (= comma25.4);
1618    put (_all_) (= datetime25.4);
1619  run;

dt1=3,743,127,970.0000 dt2=1,849,758,370.0000
dt1=12AUG2078:05:46:10.0000 dt2=13AUG2018:05:46:10.0000

If so then that value looks like it represents: 13AUG2018:05:46:10

Re: Code for time and day of the week ?

SASforHealth — Tue, 10 Mar 2020 16:04:09 GMT

ahh okay not sure why it is doing that, how odd? can you please help me craft the code then to get my Incident_DateTime into normal date, time, and day of week formats?

Re: Code for time and day of the week ?

andreas_lds — Wed, 11 Mar 2020 05:57:55 GMT

@SASforHealth wrote:

how?

Depends on the actual values you have, see the post of @ed_sas_member for a hint on how to convert text to a datetime. You could post example data, so that code could be suggested.