I have two input files. The first one, "failed_jobs", is a list of failed jobs. These will be anywhere from 1-64 characters and may have a period "." in the jobs name at different places. The second is "exceptions", these can also be from 1-64 characters with the possibility of a period in the name. I need to exclude any job that is on the exceptions list. The exceptions may be the entire jobs name, or it may anywhere from the first 2 charters to 64. Because of the variable length matching, I am having a had time figuring out how to make this happen. Any thought would be welcome.   In this example jobs PESPCD01, any PCAIM* jobs and PDUKCM01.WEB02 should be the ones excluded from the list.   data failed_jobs; input error_code $ 1 - 8 jobs $ 9 - 73; datalines; ESPPS06 PESPCD01 ESPPS06 PESPCDAD ESPPS06 POWBCMAA ESPPS06 PCAICA00 ESPPS06 PCAICM02 ESPPS06 PCAICM03 ESPPS06 PCAICM04 ESPPS06 PCAICM05 ESPPS06 PDUKCM01 ESPPS06 PDUKCM01.WEB02 ESPPS06 PESPCD02 ; run; data exceptions; input error_code $ 1 - 8 job_exceptions $ 9 - 73; datalines; ESPPS06 PESPCD01 ESPPS06 PCAIM ESPPS06 POWBCAXX ESPPS06 PDUKCM01.W ; run; * final output of failed jobs; ESPPS06 PESPCDAD ESPPS06 POWBCMAA ESPPS06 PCAICA00 ESPPS06 PESPCD02 ESPPS06 PDUKCM01 ... View more

I have a date and time being sent to me in raw text format and I need to convert it to sas data format mmddyy10. I thought I could do this with a format statement, but not having much luck. Any help would be greatly appreciated.   data rawdata;        input last_run_date $1-20;    datalines;           9-sep-2018 08:04:54  9-sep-2018 08:01:41  9-sep-2018 07:01:28  9-sep-2018 05:06:23  9-sep-2018 05:06:21  31-oct-2017 14:56:35 31-oct-2017 11:08:46 31-oct-2017 10:17:21 31-may-2015 00:01:11 31-mar-2018 12:25:20 ;                                                               data want; 09/09/18 09/09/18 09/09/18 09/09/18 09/09/18 10/31/17 10/31/17 10/31/17 05/31/15 03/31/18     ... View more

Having trouble getting a CAT function to work. I am trying to concatenate lines based on a ptr and lag_ptr. Here is my input and code OPTIONS NOCENTER;                   DATA RawData;                       INPUT ptr lag_ptr full $5 lead $7; datalines;                         0 0 A B                             0 0 B C                             5 0 C D                             5 5 D E                             0 5 E F                             0 0 F G                             ;                                     DATA want; SET RawData;                   FORMAT cat_line $CHAR05.; cat_line = " "; IF ptr = 0 THEN DO;                          cat_line=full;                         END;                                     ELSE DO;                                    IF lag_ptr = 0 THEN DO;                    cat_line=CATT(full,lead);              END;                                      ELSE DO;                                    cat_line=CATT(cat_line,lead);          END;                                   END;                                     IF lag_ptr > 0 THEN DELETE;               RUN;                                       PROC PRINT   DATA = want; VAR cat_line; cat_line A B CD F                                                   This data is missing the next value “E”.  What I wanted and have been trying to get is the data to look like this. AS you can see the E has been added to cat_line.   Cat_line A B CDE F   Any thoughts would be greatly appreciated, I have working on this for a while. Thank you!       ... View more

   I have been trying to use TRANWORD with a subsring, for example  name=TRANWRD(details,'!STREET',SUBSTR(var1,1,4);   Not sure there is a way to do this with TRANWORD or TRANSLATE. Or what is the best approach. Thx for the help in advance!   ** DATA HAVE **  VAR1      DETAILS  MAIN       OHIO.!STREET  MAIN       OHIO.!STREET  EAST       TEXAS.!STREET  RUNN      GEORGIA.!STREET  HOPP      TEXAS.!STREET    ** DATA WANT **  OHIO.MAIN  OHIO.MAIN  TEXAS.EAST  GEORGIA.RUNN  TEXAS.HOPP ... View more