I am working on Data Preparation tab in VA7.3. In one datasetfrom VALIBLA , which keeps getting refreshed , there is date timestamp column which I am trying to compare with a hardcode date. Column Type is Datetime. In where tab I am inserting expression as SAMPLEDATA.CREATE_DTTM> "01Jan2018:00:00:00"d , its giving result but showing all dates, basically not comparing . I tried using Function datepart also , which gives error that data is not parsed, though its not allowing to use Parse function. How to solve this.
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.