🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 04-03-2020 03:49 AM
(1142 views)
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
Cheers from India!
Manjeet
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
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.
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi Manjeet, Could you please post the code you tried.
Thanks,
Jag
Jag
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Look at the log(s), and post it here. Use the </> button for posting logs.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
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.