11-10-2016 11:35 AM
How can I make the excel file automatically open (in excel) once it's created (rather than navigate to the folder and manually open it)?
This is what i have:
proc export data=name
11-10-2016 11:49 AM
Proc export does not provide a trigger to open data sets since it is intended for data interchange.
Procedures that generate tabular output such as reports and such use the "View results as they are generated" setting in the Preferences tab under Tools>Options>Preferences menu.
If you want to read the results you might look towards an ODS output option with something like Proc Print.
11-10-2016 12:27 PM
If I use ODS with proc print the resulting excel file is 50mb. But with export it's 3mb. Do you know why this might be the case?
I would be open to using ODS if I could get it to be a reasonable file size, especially since I can maintain the format of my variables.
11-10-2016 01:45 PM
The size difference is because in simple data form EXCEL is actually Zipping (compressing) XML text. Try using ODS CSV to create a minimally formatted file that will open in Excel.
11-10-2016 02:07 PM
11-10-2016 03:06 PM
I'm not sure what you mean...are you talking about getting HTML and Excel results?
If so turn off ods html.
ODS HTML OFF;
ODS EXCEL ....;
ODS EXCEL CLOSE;