Adjusted_Datetime = (input(Incident_Date_time,32.) + '30dec1899'd) * 86400; sasdate = datepart(Adjusted_Datetime); time = timepart(Adjusted_Datetime); format sasdate e8601da10. time time8. adjusted_datetime e8601dt19.; yrincident=year(sasdate); monthincident=month(sasdate); day = weekday(sasdate); *code lot from incident to data entry (could also consider looking at Datetime_RecordModify); Adjusted_RecordCreate = (input(Datetime_RecordCreate,32.) + '30dec1899'd) * 86400; date_RecordCreate=datepart(Adjusted_RecordCreate); lot_incidenttoentry=date_RecordCreate-sasDate; format Adjusted_RecordCreate e8601dt19. date_RecordCreate mmddyy10. lot_incidenttoentry comma.; recordcreateday= weekday(date_recordcreate); Upon entering the above code, the table appears great.   Obs Incident_Date_Time Adjusted_Datetime day sasdate time yrincident monthincident Datetime_RecordCreate Adjusted_RecordCreate date_RecordCreate recordcreateday lot_incidenttoentry1234 42736 2017-01-01T00:00:00 1 2017-01-01 0:00:00 2017 1 42736.053958 2017-01-01T01:17:42 01/01/2017 1 0 42736.002175925925 2017-01-01T00:03:08 1 2017-01-01 0:03:08 2017 1 42765.686343 2017-01-30T16:28:20 01/30/2017 2 29 42736.006944444445 2017-01-01T00:10:00 1 2017-01-01 0:10:00 2017 1 42765.726574 2017-01-30T17:26:16 01/30/2017 2 29 42736.006944444445 2017-01-01T00:10:00 1 2017-01-01 0:10:00 2017 1 42736.720208 2017-01-01T17:17:06 01/01/2017 1 0     However, I am getting the below notes. 912 Adjusted_Datetime = (input(Incident_Date_time,32.) + '30dec1899'd) * 86400; 913 sasdate = datepart(Adjusted_Datetime); 914 time = timepart(Adjusted_Datetime); 915 format sasdate e8601da10. time time8. adjusted_datetime e8601dt19.; 916 917 yrincident=year(sasdate); 918 monthincident=month(sasdate); 919 920 921 day = weekday(sasdate); 922 923 *code lot from incident to data entry (could also consider looking at 923! Datetime_RecordModify); 924 Adjusted_RecordCreate = (input(Datetime_RecordCreate,32.) + '30dec1899'd) * 86400; 925 date_RecordCreate=datepart(Adjusted_RecordCreate); 926 lot_incidenttoentry=date_RecordCreate-sasDate; 927 format Adjusted_RecordCreate e8601dt19. date_RecordCreate mmddyy10. lot_incidenttoentry 927! comma.; 928 929 recordcreateday= weekday(date_recordcreate); NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 924:36 NOTE: Invalid argument to function INPUT at line 912 column 26. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. Incident_Date_Time=\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ Incident_Number= Adjusted_Datetime=. sasdate=. time=. yrincident=. monthincident=. day=. Adjusted_RecordCreate=. date_RecordCreate=. lot_incidenttoentry=. recordcreateday=. _ERROR_=1 _N_=543249 NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 52 at 912:56 52 at 913:15 52 at 914:12 52 at 917:16 52 at 918:19 52 at 921:11 85 at 924:63 85 at 925:23 86 at 926:42 85 at 929:22 NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to missing values. Each place is given by: (Number of times) at (Line):(Column). 52 at 912:26   ... View more

thank you, this is helpful. ... View more

thank you! ... View more

thank you so much! you have taught me a lot, I really appreciate it! ... View more

That was very helpful thank you so much for that explanation!  ... View more

I really appreciate your help and insight. That coding worked better, but the day of the week is still incorrect? When I look in a calendar I know 1/1/2017 is a Sunday, but for some reason SAS thinks it is a Saturday? I provided another variable to ground the data. incident-date_time= date of incident. datetime_recordcreate = date of record creation, which can be later than incident date. lot_incidenttoentry is the amount of days datetime_recordcreate is after incident date. I am confused why sometimes they are the same day, other times they are not. it is not following the appropriate date/time pattern? Is there a code to assure leap years are accounted for that may be affecting this?      Adjusted_Datetime = (Incident_Date_time + '30dec1899'd) * 86400; sasdate = datepart(Adjusted_Datetime); time = timepart(Adjusted_Datetime); format sasdate e8601da10. time time8. adjusted_datetime e8601dt19.;   yrincident=year(sasdate); monthincident=month(sasdate); format date mmddyy10. monthincident MONNAME.;   day = weekday(sasdate); format day DOWNAME. ;   Adjusted_RecordCreate = (Datetime_RecordCreate + '30dec1899'd) * 86400; date_RecordCreate=datepart(Adjusted_RecordCreate); lot_incidenttoentry=date_RecordCreate-sasDate; format Adjusted_RecordCreate DATEAMPM. date_RecordCreate mmddyy10. lot_incidenttoentry comma.;   recordcreateday= weekday(date_recordcreate); format recordcreateday downame.;     Obs Incident_Date_Time Adjusted_Datetime day sasdate time yrincident monthincident Datetime_RecordCreate Adjusted_RecordCreate date_RecordCreate recordcreateday lot_incidenttoentry12345 42736 01JAN17:12:00:00 AM Saturday 2017-01-01 0:00:00 2017 January 42736.053958 01JAN17:01:17:42 AM 01/01/2017 Saturday 0 42736.002175925925 01JAN17:12:03:08 AM Saturday 2017-01-01 0:03:08 2017 January 42765.686343 30JAN17:04:28:20 PM 01/30/2017 Sunday 29 42736.006944444445 01JAN17:12:10:00 AM Saturday 2017-01-01 0:10:00 2017 January 42765.726574 30JAN17:05:26:16 PM 01/30/2017 Sunday 29 42736.006944444445 01JAN17:12:10:00 AM Saturday 2017-01-01 0:10:00 2017 January 42736.720208 01JAN17:05:17:06 PM 01/01/2017 Saturday 0 42736.00813657408 01JAN17:12:11:43 AM Saturday 2017-01-01 0:11:43 2017 January 42781.74662 15FEB17:05:55:08 PM 02/15/2017 Tuesday 45 ... View more

Hi all,   You have all been so helpful, thank you x a million for all the insight you've already provided. I'm checking back in as I am unfortunately still having issues with the coding. I used the below coding and got the below notes.    3276      Adjusted_Datetime = (Incident_Date_time + '30dec1899'd) * 86400; 3277      sasdate = datepart(Adjusted_Datetime); 3278      time = timepart(Adjusted_Datetime); 3279      format sasdate date9. time time8. adjusted_datetime DATEAMPM.; 3280 3281 3282      yrincident=year(sasdate); 3283      monthincident=month(sasdate); 3284      format date mmddyy10. monthincident MONNAME.; 3285 3286      day = weekday(datepart(sasdate)); 3287      format day ;     NOTE: Character values have been converted to numeric values at the places given by:       (Line):(Column).      3276:26 NOTE: Variable date is uninitialized. NOTE: Invalid numeric data, Incident_Date_Time='-----------------------------------------------------------------------, at line 3276 column 26. NOTE: Missing values were generated as a result of performing an operation on missing values.       Each place is given by: (Number of times) at (Line):(Column).       52 at 3276:45   52 at 3277:15   52 at 3278:12   52 at 3282:16   52 at 3283:19       52 at 3286:11   52 at 3286:19   85 at 3290:52   85 at 3291:23   86 at 3292:32   When I print a few rows of observations, the data appears to be true. However, I know it is not converting appropriately since the day reads =6 but in a calendar 01-01-17 was a Sunday. proc print data=work.abc(obs=250); var adjusted_Datetime sasdate time yrincident monthincident day Incident_Date_Time; format day weekdate9. monthincident monthname3.; run; Obs Adjusted_Datetime sasdate time yrincident monthincident day Incident_Date_Time1234567 01JAN17:12:00:00 AM 01JAN2017 0:00:00 2017 January 6 42736 01JAN17:12:03:08 AM 01JAN2017 0:03:08 2017 January 6 42736.002175925925 01JAN17:12:10:00 AM 01JAN2017 0:10:00 2017 January 6 42736.006944444445 01JAN17:12:10:00 AM 01JAN2017 0:10:00 2017 January 6 42736.006944444445 01JAN17:12:11:43 AM 01JAN2017 0:11:43 2017 January 6 42736.00813657408 01JAN17:12:19:10 AM 01JAN2017 0:19:10 2017 January 6 42736.01331018518 01JAN17:12:25:47 AM 01JAN2017 0:25:47 2017 January 6 42736.017905092594           Like wise I changed the format to assess if it at least maintained a right pattern, but again it changed: proc print data=work.abc (obs=250); var adjusted_Datetime sasdate time yrincident monthincident day Incident_Date_Time; format day WEEKDAYw. monthincident MONTH.; run; Obs Adjusted_Datetime sasdate time yrincident monthincident day Incident_Date_Time1234567 01JAN17:12:00:00 AM 01JAN2017 0:00:00 2017 January Thursday 42736 01JAN17:12:03:08 AM 01JAN2017 0:03:08 2017 January Thursday 42736.002175925925 01JAN17:12:10:00 AM 01JAN2017 0:10:00 2017 January Thursday 42736.006944444445 01JAN17:12:10:00 AM 01JAN2017 0:10:00 2017 January Thursday 42736.006944444445 01JAN17:12:11:43 AM 01JAN2017 0:11:43 2017 January Thursday 42736.00813657408 01JAN17:12:19:10 AM 01JAN2017 0:19:10 2017 January Thursday 42736.01331018518 01JAN17:12:25:47 AM 01JAN2017 0:25:47 2017 January Thursday 42736.017905092594   Any thoughts or advise would be incredibly appreciated!!! ... View more

thank you for your help.   would the first step be [Then add the SAS value for '30DEC1899'd to adjust for different reference dates used by Excel and SAS. (Note that since 1899 is before 1960 the value you are adding is negative).] :   SAS_date_time = (Excel_date_time - 21916) * 86400; ... View more

hi thank you all for your help. I have tried code, but was unsuccessful: Adjustment = '30dec1899'd; Adjustment = (-1 * Adjustment); Adjusted_Datetime = (Incident_Datetime + (Adjustment * 86400)); RUN; Variable changed from: incident_datetime= 43323.24039351852 1893585723.2 as a reference this variable should be on the same day with a slightly different time datetime2= Adjusted_Datetime= 43323.240231 am i missing something? ... View more

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? ... View more

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

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 ... View more

how? ... View more

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! ... View more