Long-time fluxer, first-time poster Hi all! I desperately need advice with the following issue: I have a problem with DataFlux Data Management Studio related to SAS Base-based tables. I would like to be able to filter data in the same way as with SQL queries, but I have no idea how to achieve this using the EEL language. Simply put, my dataset includes data from different reporting months, and I would like to be able to filter the data based on various conditions, for example, according to different report dt. Additionally, the information should be retrieved from each row, not just a single max report dt from the table. Here's an example of dataflux SQL query where we get the max report dt and the next largest report dt (-1) (just to give you an idea of what I'm looking for): example.REPORT_DT = (Select MAX(REPORT_DT) from example) example.REPORT_DT >= DATEADD(day, -1, CAST(GETDATE() as date)) All ideas and suggestions are welcome 🙂 Br, Atte
... View more