topic Excel file creation from SAS 9.2 in SAS Programming

Excel file creation from SAS 9.2

mnjtrana — Fri, 03 Apr 2020 07:49:18 GMT

Hi All,

I am using SAS 9.2 and want to create excel with multiple spreadsheets. I am using SAS EG 7.1 with Unix.

However i have tried to use proc export along with DBMS=XLS, the file gets created but no data in it.

I then tried ods tagsets.excelxp, however that is not working as well.

Any suggestion to create excels in sas 9.2 would be highly helpful.

Thanks,

Manjeet

Thanks,

Manjeet

Re: Excel file creation from SAS 9.2

Jagadishkatam — Fri, 03 Apr 2020 07:54:41 GMT

Hi Manjeet, Could you please post the code you tried.

Re: Excel file creation from SAS 9.2

Kurt_Bremser — Fri, 03 Apr 2020 08:02:49 GMT

Look at the log(s), and post it here. Use the </> button for posting logs.

Re: Excel file creation from SAS 9.2

Reeza — Fri, 03 Apr 2020 16:27:26 GMT

SAS 9.2 is officially considered Ancient. If you have a valid SAS license upgrades are free or SAS UE is freely available for non-commercial purposes.

Both PROC EXPORT or TAGSETS work in 9.2 so they should work fine. For Tagsets you may want to ensure you have the latest version which is found here (latest is from 2015).

https://support.sas.com/rnd/base/ods/odsmarkup/

Example code for usage is here:
https://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html

If your code doesn't work, try the demo code as well - making sure to update the paths. This will let you know if it's your code that's wrong or something with your system.