I'm working on enhancing a MICF query. This query generates a 'CSV' file. I want to enhance the query by adding an 'Independent Source Statements' step that uses SAS ODS to send the CSV to selected parties via email. Currently, I 'hard code' the member name of CSV10010. When these queries run via a Production MICF jobstream, the member name might not be CSV10010. Is there a way to obtain the 'member name' that the query generates?
There is a macro variable &OCTKNAME that gets generated that is the member name created in the DTFOUT dataset.