topic unable to export data in excel while using stp as source in sas wrs in New SAS User

unable to export data in excel while using stp as source in sas wrs

dipanarya1 — Fri, 19 Oct 2018 13:54:16 GMT

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

Re: unable to export data in excel while using stp as source in sas wrs

Cynthia_sas — Fri, 19 Oct 2018 13:58:49 GMT

Hi:
Can you run your Stored Process using the SAS Add-in for Microsoft office, using Excel as the client application?
Cynthia

Re: unable to export data in excel while using stp as source in sas wrs

dipanarya1 — Fri, 19 Oct 2018 14:34:45 GMT

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

Re: unable to export data in excel while using stp as source in sas wrs

Cynthia_sas — Fri, 19 Oct 2018 17:26:26 GMT

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