Hi aquabu, You can create macros that queries for file records and one query that looks to see how many files to attach. macro1; does the first dataset exist and does it have records?  create a macro variable that has true or false value. mend; macro2; does the second dataset exist and does it have records? create a macro variable that has true or false value. mend; macro3; %if macro1 = true and macro2 = true %then %do; put mail code to send two attachments %end; %else %if macro1 = true and macro2 = false %then %do; put mail code to send file1 only as attachment %end; %else %if macro1 = false and macro2 = true %then %do; put mail code to send file2 only as attachment %end; %else  %do; put mail code to send an email with no attachments %end; mend; ... View more

This worked for me.  You can adapt it to fit your needs.  The code looks for an empty dataset.  If the file is empty, an email is sent to the code submitter, and the processing stops.  Otherwise, the code continues processing. %macro mailter;                     filename mymail email;                                                                                                                                                     data _null_;                                                                                                                                                                  file mymail                                                                                                                                                                      subject=(" Table does not exist or has zero observations.   &sysdate.  ")                                                                                                                                                           TO=('email@address');                       put "   The    Table OPS.SAS_NC does not exist or has zero observations.   &sysdate.         ";                                                                                                   run;                                 data _null_;                        abort abend;                    run; %mend mailter; %macro chekbetr(chekfil=ops.sas_nc);    %if %sysfunc(exist(&chekfil.)) %then %do;             /* PC SAS cannot read the metadata of the file in a remote server */             /* If the file exists, create a temporary dataset that will contain at least one? observation */             /* Then read the metadata NOBS number of the temporary dataset */                    proc sql noprint;                       drop table work.obscount;                       create table work.obscount as                      SELECT distinct a.recordid                       FROM &chekfil. as a                       ;                      SELECT distinct a.nobs into :obscnt                       FROM dictionary.tables as a                       WHERE LIBNAME = "WORK" and memname = "OBSCOUNT"                        ;                   quit;                   proc sql noprint; drop table work.obscount; quit;           %if &obscnt. = 0 %then do;                %mailter;           %end;   %end; %mend chekbtr; ... View more

Bill, Below is code that worked for me.  In my situation I did not need an "END=" line.  The PIPLOB was automatically also assigned as the END= value and that was fine for what I needed. I recommend adding the LASTREC, "OTHER" statement. Essentially the code writes        .......... value $pip "value of piplob"  = "value of product"..........other = 'N/A'....... proc sql; drop table pip; quit; DATA pip(KEEP=FMTNAME START LABEL) ;     LENGTH FMTNAME $ 8 START $ 5 LABEL $6;     set piplob END=LASTREC;     where product not = " ";     FMTNAME='$pip';     START=piplob;     LABEL=product;     OUTPUT;     IF LASTREC THEN DO;       START='OTHER';       LABEL='N/A';       OUTPUT;       END; run; PROC FORMAT CNTLIN=pip; run; ... View more