https://communities.sas.com/t5/SAS-Programming/Include-in-Set-if-has-Rows/m-p/407401#M99269 <P>Is there a way to include a table in a set statement only if it has rows?</P> Wed, 25 Oct 2017 18:09:31 GMT DavidPhillips2 2017-10-25T18:09:31Z https://communities.sas.com/t5/SAS-Programming/Include-in-Set-if-has-Rows/m-p/407401#M99269 <P>Is there a way to include a table in a set statement only if it has rows?</P> Wed, 25 Oct 2017 18:09:31 GMT https://communities.sas.com/t5/SAS-Programming/Include-in-Set-if-has-Rows/m-p/407401#M99269 DavidPhillips2 2017-10-25T18:09:31Z https://communities.sas.com/t5/SAS-Programming/Include-in-Set-if-has-Rows/m-p/407412#M99279 <P>Check nobs for the dataset beforehand (save to a macro variable), and wrap the dataset conditionally in a macro. Use that macro in place of the dataset name in the set statement.</P> Wed, 25 Oct 2017 18:20:59 GMT https://communities.sas.com/t5/SAS-Programming/Include-in-Set-if-has-Rows/m-p/407412#M99279 Kurt_Bremser 2017-10-25T18:20:59Z