PDA

View Full Version : XLSX issue after proc export from SAS 9.4



bina
2014-12-04, 12:32 AM
Hi - I am continuously experiencing the same issue whenever I export a sas dataset into excel. The newly created excel file does not allow for any filtering, or other data functions. All functions are grayed out. A filename suffix is always appearing that states '[Group]'. I use SAS9.4, Windows 7, and MS Office 2007. Has anyone experienced this before? The only resolution I have found is to close everything and reboot my computer. Then, when I reopen the excel file, all functions are active again. I am using proc export to dbms=xlsx.

Thank you!

bina
2014-12-04, 12:59 AM
Okay, I see what's happening, but couldn't delete the thread. Appears that multiple worksheets are being exported~not sure how to prevent this from happening, as it appears to create a corrupted worksheet + the worksheet I intended to export. But figured out the [Group] does go away once I deselect the multiple worksheets.

RobinmarvlMt
2014-12-24, 02:26 AM
hi2all! what are you doing at this moment? im finded funny service lmgtfy com/ a few moments ago )) can someone show me similar funny services?