topic Loop failing only for a particular data set in SAS Enterprise Guide

Loop failing only for a particular data set

sharath_rk — Wed, 05 Mar 2014 13:58:08 GMT

The below loop fails only for wk 51 & wk 52 data for FY14 Q4. The loop works fine for all other time periods. Please advise what could be the reason

SELECT (REGION);
   WHEN ('Americas')
    DO;
     IF IP_DATE = . OR DLVR_STRT_DTS = .   THEN DO;
         SDS_EXP_IP = 'N/A';
      SDS_GRD_IP = 'N/A';
      SDS_ALL_IP = 'N/A';
     END;
     ELSE DO;
      IF DATEPART(IP_DATE) = DATEPART(DLVR_STRT_DTS) THEN SDS_ALL_IP = 'MADE';
      ELSE               SDS_ALL_IP = 'MISS';
      IF SHIP_CD IN ('2','7') THEN DO;
       SDS_GRD_IP = 'N/A';
       IF DATEPART(IP_DATE) = DATEPART(DLVR_STRT_DTS) AND
                            TIMEPART(DLVR_STRT_DTS) LE "19:00"T             THEN SDS_EXP_IP = 'MADE';
       ELSE              SDS_EXP_IP = 'MISS';
      END;
      ELSE DO;
       SDS_EXP_IP = 'N/A';
       SDS_GRD_IP = SDS_ALL_IP;
      END;
     END;
    END;
   WHEN ('EMEA','APJ')
    DO;
     SDS_EXP_IP = 'N/A';
     SDS_GRD_IP = 'N/A';
     IF DATEPART(IP_DATE) = DATEPART(DLVR_STRT_DTS) THEN SDS_ALL_IP = 'MADE';
     ELSE              SDS_ALL_IP = 'MISS';
    END;
END;
END;

END;

Re: Loop failing only for a particular data set

art297 — Wed, 05 Mar 2014 14:13:18 GMT

Your error is probably coming from somewhere else in your data step.

Re: Loop failing only for a particular data set

sharath_rk — Wed, 05 Mar 2014 15:06:27 GMT

as per the line number in the error message it states that When clause is not satisfied even though there's data for EMEA & APJ

Re: Loop failing only for a particular data set

Reeza — Wed, 05 Mar 2014 15:07:52 GMT

I'd check if the DO/END matched. The way you have the code right now (indent!), I'm not about to figure it out.

The full code/error/log is also useful if you're trying to debug something.

Re: Loop failing only for a particular data set

sharath_rk — Wed, 05 Mar 2014 15:13:20 GMT

everything is matched for other time period data extractions. When i try to extract data for a specific period then i am getting the error. If i do the extraction for a week prior it works and the same goes for a week later from the specific period. Please advise.

Re: Loop failing only for a particular data set

Reeza — Wed, 05 Mar 2014 15:20:55 GMT

Post the full code/error/log.

Re: Loop failing only for a particular data set

PGStats — Wed, 05 Mar 2014 15:33:52 GMT

I think the message warns you about the fact that you've got some data where REGION is not "Americas" or "AMEA" or "APJ". Add an OTHERWISE clause to your SELECT block to detect those.

Re: Loop failing only for a particular data set

Reeza — Wed, 05 Mar 2014 15:51:25 GMT

SAS will tell you that one

ERROR: Unsatisfied WHEN clause and no OTHERWISE clause at line 552 column 1.

And you can use a list in your When Clause.

Re: Loop failing only for a particular data set

art297 — Wed, 05 Mar 2014 15:54:16 GMT

Fareeza: I deleted my post about not being able to use a list. I tested it, after posting, and then went back and deleted my post.

Re: Loop failing only for a particular data set

sharath_rk — Thu, 06 Mar 2014 08:09:50 GMT

The issue has been resolved by using the otherwise clause. IT appears the format for region name had changed for specific weeks causing the loop to fail.

Thank you so much for each one of you for the guidance.