If you're running this process every day how are you changing the file name every day? Whatever method you're using there will probably help to suggest how to add in the dates to the title. My initial suggestion is to say create two macro variables that are used to run the report and include those in the title. ... View more

It is the perception on what is coding about.. With Eguide Query builder the metadata-data information on tables and the defined relationships is the real source-code and the generates sas-code is a compiled version. Yes, the result is readable SAS-code and you can modify that manually, but it is about the process around that. There was a time Assembler guys where fighting the Cobol programmers because you could code far better coding with Assembler as with that too easy to be used Cobol (no real code challenge). You boss is an old timer you could ask where the assembly code should go and where the T-ford goes into maintenance. She won't treat you friendly when you are that unfriendly. The question would be more how could you seduce her to use he new approach. When its is more acceptable to use the generated code than that is the situation. You can add save a code node after the query-builder. By that isolating the code modification. ... View more

Thanks Chris! I'll keep class in mind too! In fact I'll test it out on my reports today and see if that works better anywhere. - Renee ... View more