I thought of this, but I am creating the date variable myself from an Excel Data/Time String... Session Start 2018-01-02 08:14:00 2018-01-02 08:26:03 2018-01-02 09:47:01 Data Test1 ; Set Usage.All_Data ; Start_Year_Str = Substr(Session_Start,1,4) ; Start_Year = input(Start_Year_Str, 8.) ; Start_Month_Str = Substr(Session_Start,6,2) ; Start_Month = input(Start_Month_Str, 8.) ; Start_Date = MDY(Start_Month,1,Start_Year) ; Format Start_DAte MonYY7. ; Run ; Output: Session_Start Start_Year_Str Start_Year Start_Month_Str Start_Month Start_Date 2018-01-02 08:14:00 2018 2018 01 1 JAN2018 2018-01-02 08:26:03 2018 2018 01 1 JAN2018 2018-01-02 09:47:01 2018 2018 01 1 JAN2018 2018-01-02 10:01:37 2018 2018 01 1 JAN2018 2018-01-02 13:31:39 2018 2018 01 1 JAN2018 Using the option Discrete as recommended by RobertAllison_SAS did the trick.
... View more