That's the exact code I have. I caught the tiny typo in your previous post and adjusted it to what you have there. Still mixing. Hmm... EDIT: Interestingly enough, it's actually picking out the data set correctly for ONEandONEptTWO, but it's still putting it in ONEptTWO as well. However, ONEptTWO does not have any data sets with solely 1.0 (at least from spot checking). So ONEptTWO looks like it's combining what should  be there with ONEandONEptTWO. ... View more

Hm. Doesn't seem to have resolved the problem. ... View more

Spot check returned a data set which had 1.0 in a 1.2 group. It also had a 2.0 in that group, so do you think that's created a problem? I wasn't anticipating this. I've made the following changes and will run the program again: (after %GLOBAL statement) %LET TWO=; (under DATA _NULL_) DO UNTIL (ONE='Y' AND ONEptTWO='Y' AND TWO='N' OR ALLDONE); ... ELSE IF VAR1=2.0 THEN TWO='Y'; ... View more

Looks like it worked! Going to do some spot checks now to make sure the data sets are reasonable. ... View more

Giving it a shot now. As it's running it'll stop on the larger data sets and I'll see a note saying that a string has become more than 262 characters long and that I may have unbalanced quotations. This program usually takes 6-8 minutes to run, and it just started. I'll let you know in a few minutes what I find. Thanks for all your help! ... View more

The program runs. However, a small issue has occurred. It's choosing to put every single table into every single category. So a table with var1 solely valued at 1.2 would end up in the 1.0 output. Is this a result of the change I've made? ... View more

Astounding, I've gone ahead and made this change. It seems to run alright now (still getting some permission errors, but the log looks good): ((ONE='Y' and ONEptTWO='Y') OR ALLDONE); EDIT: I don't know if you get a bunch of notifications that I'm marking answers as helpful/correct. Sorry about that. I removed the 'correct answer' simply because I want to make sure it outputs properly (program is currently still running) ... View more

Hey Ksharp. Thanks for the additional code. I'm running about 300+ data sets out of a specific library. They're on a DB2 server. Should the libname still be DB2, or the library I'm specifically pulling these tables from? ... View more

Hey Astounding -- here's the error log I'm getting in full. Could it have something to do with my permissions? I left that out yesterday (foolishly, more than likely) because I assumed the program would output only a permissions error if there were no other problems in the code. ... View more

On my way home for the day... wife's birthday and all. I appreciate all of your help. SQL and Macros are new for me, so this has been a great learning experience. Will check in tomorrow to see if you've replied. ... View more

Maybe I'm missing the semicolon, but here's my program: ... View more

I think the program is executing properly because I'm now getting the same error message many, many times in one run. It has to do with the library it's attempting to pull the datasets from. For instance, a common issue is that it's stating: ERROR: File WORK.dataset.DATA does not exist. ERROR 79-322: Expecting a ;. ERROR 76-322: Syntax error, statement will be ignored. This is what happens for each attempt the program makes. EDIT: Should mention that I'm looking for a specific library name. We'll call it BAGS. So all data sets will be of the form BAGS.dataset ... View more

Hmmm. Doesn't look like any semi-colons missed on my end. Shouldn't be anything after the &ONE, &ONEptTWO, and &ONEandONEptTWO statements should there? ... View more

Similar error as before. I am getting some slight output now, though. Gives me hope :smileygrin: ... View more

Alright. A good bit of it seemed to run properly. The log file was a little less clear than I had hoped from the PUT statement, but that could have something to do with what SAS considers a small error near the beginning. I'm attaching the portion of the log which contains this error. I am able to pick out the data set names correctly. This is verified when I run %PUT &VARLIST. They're all there. ... View more