BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Achraf_Ougdal
Obsidian | Level 7

Hello,

 

I have a pretty simple task that I can't find any way to do it. I created a Cross table in SAS Visual Analytics, our clients wants to exports the cross table to Excel (With the exact format that is in SAS VA, same style etc... or at least only the format)

 

The problem that I have is that I can only see two types of exports : Exports as Image and Export the Data to Excel (which exports the Data and not the table as it is).

 

Is there any other workaround ?

 

Thank you so much

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

The Add-in for Microsoft Office is included in the installation depot of the SAS software. Your SAS administrators can either install it, or give you the standalone installer file (if you have the necessary administrator permissions to install it yourself).

View solution in original post

7 REPLIES 7
Achraf_Ougdal
Obsidian | Level 7

I'm afraid it's not wirking, I am using SAS VA on SAS 9.4 and I can't find any option to Copy/Paste the table or any other object. I tried to use Ctrl+C and Ctrl+V but unfortunately it's not working either.

MarkusWeick
Barite | Level 11

@Achraf_Ougdal,

I haven't used Excel with VA it myself so far, but have a look at

SAS Tutorial | Working with SAS Visual Analytics Reports in Microsoft Excel - YouTube.

It might give you some ideas.

Best

Markus

 

Please keep the community friendly.
Like posts you agree with or like. Mark helpful answers as “accepted solutions”. Generally have a look at https://communities.sas.com/t5/Getting-Started/tkb-p/community_articles
Achraf_Ougdal
Obsidian | Level 7

Thank you for your reply, Yes I saw the video, it requires an add-in for Excel and it's not available for download for free. I'm perfectly aware that this will solve our problem entirely but since we cannot purchase the Add-In, I was wondering if there's another Way to do it ?

Kurt_Bremser
Super User

The Add-in for Microsoft Office is included in the installation depot of the SAS software. Your SAS administrators can either install it, or give you the standalone installer file (if you have the necessary administrator permissions to install it yourself).

Achraf_Ougdal
Obsidian | Level 7

Can you please show me the path to where is it included ?

Kurt_Bremser
Super User

IIRC, the SAS depot has a directory called Standalone Installers. You should find it there.

 

It's been some time since I did my last BI Server installation.

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!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 7 replies
  • 1195 views
  • 4 likes
  • 3 in conversation