@Randy1 wrote:
Ballardw, I removed the BY statement in the code below and it ran. Do you know why that would mess it up?
DATA TEMP1; SET QUERY_FOR_MERGE_STORET_SRBT_0006; BY Organizati POINT_X POINT_Y DATE YEAR SLID_Rep; IF Var1='X' and Var2>1 THEN DELETE; RUN
If that code did not yield the result desired I would suspect soem error to appear in the log. Most likely would be something like a sort order error or possibly one of the variables on the by statement. If the log shows something like:
ERROR: BY variables are not properly sorted on data set
then the resulting set would not be replaced. If you have an existing temp1 created incorrectly then that would be what you would see when you examine the values in Temp1. Or
ERROR: BY variable <any of your variables on the by statement> is not on input data set
would also not replace an existing Temp1.
... View more