Hello, I played around some with your Proc SQL example and came up with the below which is now getting the correct results.  The observation that has value4 = '2' and value5 ne '1234' also has to be in the group written to the output dataset given that the other two conditions are also met.  I end up getting nine observations written to the output dataset which also has the correct groups in it. proc sql;   create table want as      select * from have          group by value1,value2 having              (sum(catx('  ',value4,value5,value6) = '3 1234 1') or               sum(catx('  ',value4,value5,value6) = '5 1234 1') and              (sum(value4 = '2' and value5 ne '1234')); quit; William ... View more

It's a little trickier extract, but this looks pretty close.  For the last "sum" line, the criteria has to be Value4 equal to 2 and Value5 not equal to '1234'.  Out of curiosity, what does the "eq 0" part do? William ... View more

Hello, I tried your suggested Proc SQL code above, but I get all 18 observations written to the output dataset.  Given the newer extract criteria, would expect the groups of observations to be excluded from the output dataset would be: - first grouping of data (first three obs) under Value1 = 01 due to the first observation in the group having Value4 = 2 and Value5 = 1234, and the third observation having Value6 = 2), and - first grouping of data (first three obs) under Value1 = 02 due to the first observation in the group having Value5 = 1234, and the second and third observations having Value5 = 1236 and 1235, respectively, and - second grouping of data (second three obs) under Value1 = 03 due to the first observation in the group having Value5 = 1234 The other three groups should make it into the output dataset.  I guess this extract is a little trickier. William ... View more

Below is the Proc SQL code I was trying to use for the above conditions.  I keep getting an empty output dataset. proc sql;   create table want as       select * from have             group by value1,value2 having             sum (catx ('  ',value4,value5,value6) = '3 1234 1') and             sum (catx ('  ',value4,value5,value6) = '5 1234 1') and             sum (catx ('  ',value4) = '2' and sum (catx ('  ',value5) <> '1234') gt 0; quit; ... View more

Using the above 18-line data example, I am currently trying to do a slightly different data extract.  This is a little more involved but Value1 and Value2 are still used to identify each grouping and all variables are still character.  The new extract criteria is:  if Value4 is equal to 3 or 5, and Value5 is equal to 1234, and Value6 is equal to 1, and if Value4 = 2 and Value5 is NOT equal to 1234, then write that group to the output SAS dataset. I can't figure out how to handle/incorporate the latter condition (i.e., "and if Value4 = 2 and Value5 is NOT equal to 1234") with the set of conditions before it. William ... View more

My apologies, I inadvertently used an incorrect Value5 in my extract criteria.  The Proc SQL code worked and got what I needed.  Thanks so much for your help! William ... View more

My actual data does have Value4 of 2s, which are also inputted as character format.  The Value5 values (also inputted as character) are actually six-digit numbers (just did them as four-digits here for illustrative purposes).  Also, there is no summing done in the mathematical sense. Just trying to extract certain observations (records) from a database based on the criteria noted, and then output the records to a separate dataset. William ... View more

The Value4 and Value5 are both character variables.  Also, yes, both Value1 and Value2 would be needed to identify unique groups.  The Value1 is basically a fictitious code (for, let's say, a State), and Value2 is simply a unique fictitious number identifier of each group within each Value1.  In other words, there will be many unique Value2's within each Value1. ... View more

One additional note.  I bring in the data from an external text file via a data step using infile and input statements.  However, the suggested Proc SQL code used was from Xia. William ... View more

I tried Xia's code.  I do get a SAS dataset created, but with no observations and six columns.  Also, the SAS Log shows a message that says "The query requires remerging summary statistics back with the original data." ... View more

I expanded the data example somewhat to be more realistic.  See below.  Given the same value4 and value5 extract criteria, the first group of obs for value1 = 01 would be pulled, the first group of obs where value1=02 would be pulled, and the second group of obs where value=03 would be pulled.  Would this change your code solution any? Value1   Value2   Value3   Value4   Value5   Value6 01          123         00          2            1234       1 01          123         01          3            1235       1 01          123         02          3            1234       2 01          127         00          2            1237       1 01          127         01          3            1234       1 01          127         02          3            1234       1 02          124         00          2            1234       1 02          124         01          3            1236       1 02          124         02          3            1235       1 02          128         00          2            1238       1 02          128         01          3            1234       1 02          128         02          3            1234       1 03          125         00          2            1230       1 03          125         01          3            1234       1 03          125         03          5            1235       1 03          129         00          2            1234       1 03          129         01          3            1234       1 03          129         02          3            1234       1 ... View more

Thanks so much for the help! ... View more