I'm moving "regular" SAS jobs into EG, hopefully without just lumping it into a Code Node. My current job pulls data from an Oracle dataset, transforms some variables, and saves the result elsewhere as a SAS dataset.
I started with the Filter and Query task, but I'm stymied on how to get the following dataset-level things done (currently done with dataset options):
- compress option
- dataset password (for write= and alter=)
- index creation
- dataset label
- sortedby assertion (probably redundant with the index creation, but...)
Is this possible in EG? If so, can it be done without multiple tasks?