I'm having a pretty strange problem. I've got a script with several macros that works fine when run manually in a SAS session, but fails if automated. I'm in a Solaris UNIX environment, and so my SAS jobs are automated via cron jobs. I've had similar jobs (and an earlier version of the script I'm having problems with) running for years without issues.
The strange part is, the script fails where it is trying to execute a data step to reduce a large data set down with a where statement. When run manually the result is a dataset with over 1000 rows. When run under automation the result is an empty data set - because the source data set appears empty! This step is part of a loop, and in this case it is the second time the loop executes. The first time it executed everything was fine.
There is a second data set that is empty at this step that shouldn't be. This data set is one that I build with datalines before executing the macro. As far as I know there are no functions in my script that should be deleting the contents of all my data sets. I've got a lot of options set (mprint mprintnest mlogic mlogicnest symbolgen serror merror source source2) to try and get more info, but nothing is pointing to an obvious problem.
I know this isn't much to go on, but does anyone have any thoughts? Is there some more debug functions I can enable to try and get more info as to what is happening?