I load a table to do lookups but if I search the table with a key that was just found, I get a not found _IORC_ returned. Do I need to reset something before my next lookup? LOOKUP KEY = 22 KEY1=ABCTA PREFIX     = 22 PREFIX=D MATCH GOOD = 22 KEY1=ABCTA LOOKUP KEY = 23 KEY1=ABCTA PREFIX     = 23 PREFIX=D NO MATCH FOR = 23 KEY1=ABCTA Example: DATA LOOKUP(INDEX=(KEY1)); INFILE LOOKUP END=EOFIND1;     INPUT @1  KEY1    $08.   @10 OUTID $03.; RUN; KEY1 = 'ABCTA'; SET LOOKUP KEY=KEY1;    /* CHECK RETURN CODE FROM SEARCH */ SELECT (_IORC_);   /* MATCH FOUND */   WHEN (%SYSRC(_SOK)) DO;     PUTLOG 'MATCH GOOD = ' _N_ KEY1=;     FILE GOOD;     PUT @1  KEY1           @10 STUFF;   END;   /* MATCH NOT FOUND IN MASTER */   WHEN (%SYSRC(_DSENOM)) DO;     _ERROR_=0;     /* RESET VALUES IN PDV FROM LAST MATCHED CONDITION */     PUTLOG 'NO MATCH FOR = ' _N_ KEY1=; END; ... View more

I need to load 2 tables, do a lookup in one(Table 2) and get a value from there, and look up that value up in Table 1. Example: Table 1 (key=12 bytes) ex. JOB00004 013 - has: JOB00004 013 JOB00009 000 JOB00026 013 JOB00099 011 Table 2 (key=12 bytes - same as Table 1) has: JOB00001 011 JOB00077 JOB00004 013 JOB00026 JOB00009 011 JOB00099 Read input file and do a "lookup" in Table 2 example Input record1 = JOB00001 999 -  not found - put to error file Input record2 = JOB00004 013 - record found in Table2 - now take JOB00026(field after 12 byte key) and do a lookup in Table 1 - JOB00026 Found in Table1 I am not clear on how to load these into 2 tables and do the lookups and handle the "not founds", etc... I have read the "SAS coding by examples" by Ron Cody and still am unclear. Any help is appreciated. Thanks ... View more

I read paper 217-2007 SAS character functions by Ronald Cody and checked the 9.2 reference manual with no luck. I am reading an 80 byte file in MVS and writing it back out and modifying certain records. I want to retain the leading spaces and blank lines in my output file. It looks like SAS is dropping the blank lines and the output is truncated to the left. I tried using a format of FORMAT WHOLE1  $CHAR80.; output = ------- report heading 1 ------- Jobs Report Job1 Job2 ------- report heading 2 ------- jobx joby Any recommendations? Sample of records; datalines: 1 -------- report heading 1 ------- 2 3           Jobs Report 4 5           Job1 6          Job2 7 8 ------- report heading 2 ------- 9          10          jobx 11          joby ... View more

I am trying to total up some times and print them out to no avail. when I do a PUTLOG on TOTALTIME it says 0; I've tried doing a PUT with TIME5. and still no success. I am trying to RETAIN and sum up the DURATION time - any recommendations to accumate time for hours and minutes? RETAIN TOTALTIME; DATE_START=INPUT(BEGINDT, JULIAN7.); DATE_END=INPUT(ENDDT, JULIAN7.); TIME_START=INPUT(BEGINTM, TIME10.); TIME_END=INPUT(ENDTM, TIME10.); DURATION=(DATE_END*86400+TIME_END) - (DATE_START*86400+TIME_START); TOTALTIME =(TOTALTIME + DURATION); PUTLOG 'TOTALTIME =' TOTALTIME; ... View more