What are the benefits of SAS 9.4 over 9.2

[Reeza]

proc print the dataset within the ODS open/close statements, similar to what you would do if using ods tagsets.excelxp.

[brophymj]

Reeza, thanks but I don't follow. Could you give an example of code you would use to achieve this?

[Reeza]

ods excel file='/folders/myfolders/sample.xlsx' style=minimal options(sheet_name='test');

proc print data=sashelp.class noobs;

run;

ods excel close;

[brophymj]

Thanks Reeza, that worked

Is there a way to stop excel from opening?

Also, can you populate multiple sheets this way?

Thanks

[LinusH]

Since this differ quite a bit from the original question, I suggest that you open a new thread.

Also, there are tons of examples/doc on Excel tagsets. Browse these forums/support.sas.com and get back for further questions.

And back to the orifinal question: if you just got Base SAS, and do not plan to use a different OS or change bit (32 -> 64), there is nothing that should hold you back. No need for migration of your data/programs etc. Upgrade is included in your license.

[Reeza]

DS2 is a new language available in SAS 9.4