proc print the dataset within the ODS open/close statements, similar to what you would do if using ods tagsets.excelxp.
Reeza, thanks but I don't follow. Could you give an example of code you would use to achieve this?
ods excel file='/folders/myfolders/sample.xlsx' style=minimal options(sheet_name='test');
proc print data=sashelp.class noobs;
run;
ods excel close;
Thanks Reeza, that worked
Is there a way to stop excel from opening?
Also, can you populate multiple sheets this way?
Thanks
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.
DS2 is a new language available in SAS 9.4
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.