Hi, You can create an excel workbook with multiple sheets using eg. The important thing is the file name. Find out the name of the location where you have permission on the SAS server. You can run something in EG and read the log, and it will diplay the file path. The code below will create one excel workbook with one sheet, if you want multiple sheets then after the run statement type QUIT; and repeat all steps but not #1 and not #3. Because you only need one file statement to create a workbook, but you need a to repeat all the steps to created multiple sheets. After you run it, you click on results and youll get a promp asking you if you want to open the file, and it may give you a warning, but just go ahead and click yes, then an excel icon will appear and pulsate, and after you click on the icon, your output will open in a nice formatted excel spreadsheet. You can add all kinds of options, but you can look those up yourself. I am submitting a paper to SUGI, it seems that there are a lot of people who have to use EG, but dont know that you can simulate the good old proc export like we use too in BASE SAS. Best, R Then Here is the code: 1.ods _all_ close; 2.ODS MARKUP TAGSET=TAGSETS.EXCELXP 3.file='/var/opt/data/userdata/--->>>...type your name/userid here...<---./file_name.xls' 4.style = statistical 5.options( put any option you want) 6.proc print data=your data name and options; 7. var your_var_name/style= [ your options]; 8.run; 9.ODS TAGSETS.EXCELP CLOSE; 10. ODS LISTING;
... View more