If you use proc export, each proc export call will create a new file (=workbook).   Once files are created, filename email in SAS allows to attach files.   As already advised, sending datafiles per email is not good. Providing files for download with sftp(SSH) or https is the way to go. ... View more

The general concensus for such a request, is don't do it. SAS provides many methods for dealing with grouped data. No one usually listens though.    https://blogs.sas.com/content/sasdummy/2015/01/26/how-to-split-one-data-set-into-many/   @shikpop wrote: I would like to create a new dataset for a different value in where. For Example I have data for 11 managers and I would like a seperate dataset for each manager How do I accomplish a new table for a different name of the manager in where clause of proc sql     ... View more