I am working on a project that requires me to use a schedule chart. I have 2 variables in a similar format.
1) CLASS START DATE (data format: d/m/yyyy hh:mm)
2) CLASS END DATE ((data format: d/m/yyyy hh:mm)
Part of the project requires me to get the time portion of the data. So naturally, i used this formula below:
to which yielded the desired outcome of only the time portion of the data being displayed as shown below:
However, when trying to apply the same technique/formula to the second variable, Class End Date, the results yielded a different result as below
As shown in the picture below, the values are shown only as 0:00. I went back to the source data to recheck and reconfirm the data format/type but could not find any errors/irregularities.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.