SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
mnjtrana
Pyrite | Level 9

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
Reeza
Super User
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.


View solution in original post

3 REPLIES 3
Jagadishkatam
Amethyst | Level 16
Hi Manjeet, Could you please post the code you tried.
Thanks,
Jag
Reeza
Super User
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.


sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1143 views
  • 2 likes
  • 4 in conversation