I ended up completing the project while stoping the code manually, and changing the info, and restarting... it's just that it takes 6 hrs to pull all the data... and i wanted this to run overnight with little to no intervention so i can get in the morning and move on to the next task and not have my system tied up all day waiting for this to run and constantly paying attention to it to make sure i'm inputting stuff as needed. I now have a little bit of downtime and thought I would circle back to this to see if I could figure it out. Astounding, this just might be what i was looking for. most of that code is still foreign to me (only been using SAS for about 10 months, no prior coding/SQL experience). Especially the last bit of code - the proc sql sleect count. I think i understand what it's supposed to do... but i can't get it to do it... But thank you for the response. I will play with this! Fingers crossed!
... View more
