Date (UTC) User Username 2020-08-31:20:46:49 I combined my date and time columns to make the column DATE (UTC) as above and ran the code as follows (they where separate date and time columns) ;   data ral.Sigins_dups_Removed1; set ral.SIGNINS_COMBINED; by username 'Date (UTC)'n; if first.username; run;   It is not giving me the the first sigin by day anymore, any idea what I need to change? ... View more

@SASKiwi @Shmuel    Thanks for the help. I renamed the variables and that solved it.  ... View more

1) the code   data ral.SIGNINS_COMBINED_NZTIME; set ral.SIGNINS_COMBINED_2; hh = hour(time); mm = minute(time); ss = second(time); UTC_datetime = dhms(date,hh,mm,ss); NZST_datetime = intnx('DTHOUR', utc_datetime, 12, 'SAMEDAY'); format utc_datetime NZST_datetime datetime22.; run; ... View more

NOTE: Variable time is uninitialized. NOTE: Variable date is uninitialized. NOTE: Argument 2 to function INTNX('DTHOUR',.,12,'SAMEDAY') at line 38 column 21 is invalid. WARNING: Limit set by ERRORS= option reached.  Further errors of this type will not be printed. 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).       750000 at 34:11   750000 at 35:11   750000 at 36:11   750000 at 37:20   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).       750000 at 38:21   NOTE: There were 750000 observations read from the data set RAL.SIGNINS_COMBINED_2. NOTE: The data set RAL.SIGNINS_COMBINED_NZTIME has 750000 observations and 38 variables. NOTE: Compressing data set RAL.SIGNINS_COMBINED_NZTIME decreased size by 69.63 percent.       Compressed is 5555 pages; un-compressed would require 18293 pages. NOTE: DATA statement used (Total process time):       real time           11.45 seconds       cpu time            3.41 seconds     When I run option 3;       Obs date time UTC_datetime NZST_datetime 1 . . . . 2 . . . . 3 . . . . 4 . . . . 5 . . . .   NOTE: There were 5 observations read from the data set RAL.SIGNINS_COMBINED_NZTIME. NOTE: PROCEDURE PRINT used (Total process time):       real time           0.06 seconds       cpu time            0.01 seconds ... View more

I ran the following but there was no data in the columns added;    data ral.SIGNINS_COMBINED_NZTIME; set ral.SIGNINS_COMBINED_2;      hh = hour(time);      mm = minute(time);      ss = second(time);     UTC_datetime = dhms(date,hh,mm,ss);     NZST_datetime = intnx('DTHOUR', utc_datetime, 12, 'SAMEDAY');    format utc_datetime NZST_datetime datetime22.; run;   ... View more

This is awesome, forgive me I'm a noob using SAS. I've combined them, datetime in a column. Your code does exactly want I want but how do I get it to apply to the million rows of data I have?   ... View more

I've combined the columns to make them datetime, data below, any help would be much appreciated.   Date (UTC) 2020-05-06:03:03:57 2020-05-06:03:03:57 2020-05-06:03:03:57 2020-05-06:03:03:57 2020-05-06:03:03:57 2020-05-06:03:03:56 2020-05-06:03:03:56 2020-05-06:03:03:56 2020-05-06:03:03:56 2020-05-06:03:03:56 2020-05-06:03:03:55 2020-05-06:03:03:55 2020-05-06:03:03:55 2020-05-06:03:03:55 2020-05-06:03:03:55 2020-05-06:03:03:55 2020-05-06:03:03:54 2020-05-06:03:03:54 ... View more

Date Time (UTC) User 6/05/2020 03:57.9 GG 6/05/2020 03:57.4 DD 6/05/2020 03:57.2 AA 6/05/2020 03:57.1 HH 6/05/2020 03:57.0 AA 6/05/2020 03:56.8 II 6/05/2020 03:56.8 AA 6/05/2020 03:56.7 BB 6/05/2020 03:56.4 DD 6/05/2020 03:56.1 HH 6/05/2020 03:55.9 AA 6/05/2020 03:55.7 GG 6/05/2020 03:55.5 FF 6/05/2020 03:55.4 CC 6/05/2020 03:55.1 EE 6/05/2020 03:55.0 DD 6/05/2020 03:54.8 CC 6/05/2020 03:54.8 BB 6/05/2020 03:54.7 AA ... View more

It ran when I used yours, I am assuming it was the = in the beginning or the order. If I wanted to have a table of the counts in those date ranges what would the code for that look like? ... View more

Quick question, what would I have to add to the code to get the table names to appear? ... View more

Thanks for this, it did the trick. ... View more