BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I "right click" in the WRS table and "export", then choose EXCEL and OPEN.
For me, the report opens inside EXCEL .
However for other users in my company it opens "inside" microsoft Explorer.
(only saving it and reopening will open Excel with the worksheet inside).
Anyone can tell me why?
3 REPLIES 3
AngelaHall
SAS Employee
My guess is that this is actually related to Windows rather than SAS.

For your machine, the file type extensions have allowed this type of file to be opened by Excel. Determine the file type that is being opened by default from this export. Then compare the machines. Check on the file type assignments (in Windows Explorer, go to Tools -> Folder Options, and move to the File Type tab).

~ Angela
deleted_user
Not applicable
Thanks... I got the answer (Angela's reply took me part of the way)...
Under "folder options" there is an "ADVANCED" botton .
It has a checkbox "open in the same window" ,
so since the WRS is in explorer, it forces excel to open in explorer.
UNCHECK this and the WRS table will open in "regular" excel.
Note: Sometimes to do that the user needs to be "local admin" on the PC.
Regards!
AngelaHall
SAS Employee
Great news! Thanks for the update & resolution information!

~ Angela

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
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
  • 1115 views
  • 0 likes
  • 2 in conversation