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

Hi Team,

 

I am unable to export data in excel while using STP as source in SAS WRS.

 

Please find list of steps below:

 

1. Open Report in SAS WRS which is using the STP as an source

2. Cross Table is used to represent the data

3. To export the data click on "File> Export" under SAS WRS file option

 

Please let me know if it is feasible or do we have any other option to enable the option.

 

Thanks and Regards,

Dipan Arya

1 ACCEPTED SOLUTION

Accepted Solutions
Cynthia_sas
SAS Super FREQ
Hi:
It's been a while since I taught the Web Report Studio class. I remember an Export to PDF capability when you were looking at a WRS report. But I do not remember an Export to Excel feature.

You might want to open a track with Tech Support on this.
Cynthia

View solution in original post

3 REPLIES 3
Cynthia_sas
SAS Super FREQ
Hi:
Can you run your Stored Process using the SAS Add-in for Microsoft office, using Excel as the client application?
Cynthia
dipanarya1
Obsidian | Level 7

Hi @Cynthia_sas,

 

The client has some specific requirement to use SAS WRS for viewing the report and also client does not have SAS Add-in for MS Office product license.

 

Thanks and Regards,

Dipan Arya

 

Cynthia_sas
SAS Super FREQ
Hi:
It's been a while since I taught the Web Report Studio class. I remember an Export to PDF capability when you were looking at a WRS report. But I do not remember an Export to Excel feature.

You might want to open a track with Tech Support on this.
Cynthia

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 699 views
  • 0 likes
  • 2 in conversation