cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
AlexSP
‎10-05-2021
  • 7 Posts
  • 0 Likes Given
  • 1 Solutions
  • 0 Likes Received

Re: Compatibility between date types

by Fluorite | Level 6 in SAS Programming
‎09-30-2021 04:31 PM
‎09-30-2021 04:31 PM
Eureka! Solution for this problem: * Select 1: datepart (dac.dtc_credito) format = mmddyy10. as D1 UNION * Select 2: ajt.DTC_MOV as D1 Result: 05/03/2021, as desired. Thanks PaigeMiller, Tom, BallarDW for the help. ... View more

Re: Compatibility between date types

by Fluorite | Level 6 in SAS Programming
‎09-30-2021 04:05 PM
‎09-30-2021 04:05 PM
Correcting * Select 1: dac.dtc_credito format = datetime22.3 as d1 union * Select 2: ajt.DTC_MOV format=datetime22.3 as d1 Result: 01JAN1960:06:19:28,000 ... View more

Re: Compatibility between date types

by Fluorite | Level 6 in SAS Programming
‎09-30-2021 04:03 PM
‎09-30-2021 04:03 PM
Analysts here don't know either. As there is an appreciation of IT professionals (which is good) old analysts who had more knowledge have already left. I put this code ajt.DTC_MOV format=datetime22.3 in both selects. The result is in the correct format, but with the wrong result: 01JAN1960:06:19:28,000 instead 03MAY2021. * Select 1: dac.dtc_credito format = datetime22.3 as d1 union * Select 2: ajt.DTC_MOV format=datetime22.3 as d2 Result: 01JAN1960:06:19:28,000 ... View more

Re: Compatibility between date types

by Fluorite | Level 6 in SAS Programming
‎09-30-2021 03:26 PM
‎09-30-2021 03:26 PM
PaigeMiller, I have not permission to share the LOG.  Ballarddw, In Excel I have the dates like 03/05/2021 04/05/2021 * First select I have date in the format 03MAY2021:00:00:00.000 (numeric, datetime 22.3 format) * Second select (over the Excel) I have date in the format 05/03/2021 (numeric, mmddyy10. format). *but After UNION I got the date in the format like 1935705600 Tom, I have used your solution but it did not work. As I am new in SAS programming, I am reading all I can to understand how dates function works to be able to alter the date.  ... View more

Re: Compatibility between date types

by Fluorite | Level 6 in SAS Programming
‎09-30-2021 12:48 PM
‎09-30-2021 12:48 PM
Unfortunately due to organizational rules I cannot share such material. But I keep trying to resolve this issue of the date. ... View more

Re: Compatibility between date types

by Fluorite | Level 6 in SAS Programming
‎09-30-2021 11:11 AM
‎09-30-2021 11:11 AM
Thank you for your prompt response, but the result is still in the 1924214400 format. ... View more

Compatibility between date types

by Fluorite | Level 6 in SAS Programming
‎09-30-2021 10:39 AM
‎09-30-2021 10:39 AM
Hi! I performed a union between two selects. In the first select the date field (ajt.DTC_MOV)) is numeric in datetime 22.3 format. The results are in the format 03JAN2019:00:00:00.000. In the second select, the date field (ajt.DTC_MOV) is numeric without a defined format (the dates are extracted from an excel spreadsheet). The results are in the format 1935705600. When performing the UNION data field it shows the results in the format 1935705600. My question is how to display them in the format 03JAN2019:00:00:00.000. I've tried the solutions below without success in the select clause: - DHMS(ajt.DTC_MOV,0,0,0) - datepart (DHMS(ajt.DTC_MOV,0,0,0)) format = datetime22.3 - datepart (ajt.DTC_MOV) format = datetime22.3   Thanks. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-05-2021 02:25 PM
Group Hubs for AlexSP
View All
Quick links