Sunil:
Sorry, my bad, I was not clear in my explanation. EG does NOT have the option to return CSV from a toolbar/menu choice. That option only exists within Excel under the SAS Add-in for Microsoft Office -- by clicking
SAS --> Options --> and then looking for either the Results tab or the Stored Process tab to change the result format to CSV(I'm not at a computer with the BI image right now, so I can't check).
EG, of course, returns the MAIN ODS result types -- HTML, RTF, PDF and SASReport XML via a menu choice. But, there is not a Tools--> Options choice to return CSV. To create a CSV file, you would have to use code within a code node. However, if you submitted the code shown in my previous post, from within EG, you would essentially see a "Notepad-type" window with the CSV results.
The point that I was trying to make is that having EG make CSV output as a menu choice just doesn't make a lot of sense, when you can do a direct export of results to Excel with a Right-Mouse click or can run a stored process in Excel whose results can be returned as CSV. (This same logic applies to Microsoft Word -- if you look at the menu choices for result types in Word, you will not find CSV listed -- that's because Word doesn't really -do- anything with a CSV file. There's no menu choice in Excel for returning RTF results, because Excel doesn't know what to do with RTF results.)
So, there's no menu choice in Excel for automatic creation of CSV files. If you need to create a CSV file in a project, then your choices are a PROC EXPORT code step to export a SAS data set to CSV format or have an ODS CSV code step to return procedure results as a CSV file.
I hope this explanation makes my previous post clearer.
cynthia