Does anyone know how to append additional information to an excel spreadsheet using ODS HTML? Need to add several hundred records, but obviously don't want to add that number of additional pages in excel.
Hope this makes sense!
Joe
Just come across this one!
You could alternatively try writing the following code at strategic parts of your program:
DM 'Clear log' ;
DM 'Clear Out' ;
Say, after each instance of writing something to the output - proc report/tabulate/print etc.
Silly question(s) maybe.
Have you tried running the code 'stand alone' without using macros to see whether there are errors?
There may be additional code within your SQL step, but as it reads there, why do you need to use SQL for what appears a straightforward subset? Wouldn't a proc sort with...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.