I think you want to use the DATA step and output more than one table. You just need to find the right statements with the correct conditional logic. The following example might work as long as Y has no missing values--remember a missing value in SAS is actually a negative number (tiny, but still a value).
Data First Second;
Set Have;
if Group = 'Group 1' and Product = 'A' and Y < 0 then output First;
else if Group = 'Group 1' and Product = 'A' and Y >= 0 then output Second;
Run;