Excel file creation from SAS 9.2

[mnjtrana]

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

[Jagadishkatam]

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

[Kurt_Bremser]

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

[Reeza · Accepted solution]

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.