What do you intend by "for visualization"? Typically that would mean some sort of graph to me. At which point it may be time to learn SAS graphing tools as I'm willing to bet a lot more can be done in SAS than you want to try in Excel. For examples wander around here Graph Samples Gallery | SAS Support starting with Sgplot, Sgpanel and Sgrender.   If not graphs describe what your "visualization" might actually be.   After you have the data sets built you can use ODS Excel to send the data sets to the same excel sheet with something like: ods excel file="path from root of drive\yourfilename.xlsx"; proc print data=controlsdataset; run; proc print data=casesdataset; run; ods excel close; or the names of any data sets you have. In the above each data set would go to a different sheet in the workbook. Caution: SAS data sets can be much bigger than Excel will accept. So if you have much more than a million observations in any data set you will have problems with anything involving Excel. ... View more