Hello I am using SAS version 9.3 and EG version 5.1. I have seen some of the other posts about exporting to multiple worksheets in Excel, which I will try, but I'm not sure how to save the data to know what is per worksheet. I have a data set of patient data and I am running various data quality checks on it. The required fields for each criteria may differ but I want each criteria to be its own Excel worksheet. So do I save each criteria as its own dataset to be sent to Excel as a separate worksheet or do I create one dataset with a column of "DQ flag" to identify the criteria the case matches? Thanks.
