In Status Handling for jobs and transformations there are some default conditions and actions where you could do such things. Unfortenately there is no default condtion of a certain table has zero rows, So depending on what leads up to you having zero rows, you might be able to use a condition of Data Modified?   Otherwise you could code this fairly easy, perhaps write a macro that check no of obs given your table of interest, and then force the SAS job to quit using ABORT ABEND. Insert the macro either as a post processing for the transformation or the job. Or you could bundle it into a User Writter Transformation to make it visible in the job canvas.  ... View more

The data from your input stream is stored in a dataset, not a macro variable. When you add an ampersand - &SSNList - you are referencing a macro variable, which in your case doesn't exist.   You can alter your code so that the filter selects all the contents of your dataset, SSNList. One way is by editing your where statement with a subquery like:   WHERE t1.SSN IN (select [insert name of your SSN column from the input stream] from SSNList) Don't forget to include the headers in your input stream, when you specify the range in Excel.   Alternately you can do it with a join: FROM Test1.XXX_Address_VW t1 left join SSNList t2 on t1.SSN=t2.[insert name of your SSN column from the input stream] ... View more

Linus - I have called several SPs via SAS successfully. This is the first time trying to use today's date for the parameter.   Thank you ... View more

The following works for me (using Windows10):   filename DIRLIST pipe 'dir "c:\art\*.csv" /tw '; data dirlist (keep=InFile_name date); informat date yymmdd10.; format date date9.; informat time time8.; format time time5.; informat size comma12.; informat InFile_name $100.; infile dirlist lrecl=200 truncover; input date time ampm $ size InFile_name; if not missing(date); run; Art, CEO, AnalystFinder.com ... View more