Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS VA : Date Comparison in Query Builder not giving correct Result

Reply
Occasional Learner
Posts: 1

SAS VA : Date Comparison in Query Builder not giving correct Result

Hi All,

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.

Super User
Posts: 4,034

Re: SAS VA : Date Comparison in Query Builder not giving correct Result

Posted in reply to dmalhotra

If you are comparing with a datetime constant then try this: SAMPLEDATA.CREATE_DTTM> "01Jan2018:00:00:00"dt

Ask a Question
Discussion stats
  • 1 reply
  • 131 views
  • 0 likes
  • 2 in conversation