@Renato_sas absolutely!
The goal was to give the client ability to download an excel of the cross tab in the report.
In our current Viya 3.5 environment, the only way to download the crosstab data directly from VA is in it's raw format (long). Initially I had a JES job that allowed them to download the data in the same view as cross tab (wide view). This approach was limited because there was no way to subset the data based on their chosen filters in the report. Everytime they downloaded to excel, it would be the full table and they would have to perform filtering in excel to match the report view.
With the information from this article, I was able to integrate a DDC object that would pull the already subset data they were interested in into a job, use SAS code to adjust the formatting and view, and have it download client side.
My client will now be able to download the exact subset of the data they are interested in vs having to download a huge table when they only need a small piece. Thank you!
We will definitely be using this across many projects.
... View more