topic Re: option to increase number of rows from Export in SAS Visual Analytics

option to increase number of rows from Export

ArpanGhosh1 — Fri, 22 Jan 2016 10:03:14 GMT

Hi Experts,

Currenlty when i try to export the underline data from a report object in excel, i could get only 50,000 rows.

Is any configuration change, by virtue of which we can increase the number of exported rows.

I am using SAS VA 7.1

Regards

Arpan

Re: option to increase number of rows from Export

RW9 — Fri, 22 Jan 2016 10:08:39 GMT

I have no idea I am afraid as I don't use VA. However I would ask for what purpose do you intend to export >50k rows to Excel? Nobody will ever look at that data. If your doing a transfer of data, I would strongly suggest that you use a proper data transfer format - CSV, XML, etc. Unless you absolutely have to use Excel, don't.

Re: option to increase number of rows from Export

ArpanGhosh1 — Fri, 22 Jan 2016 10:11:50 GMT

We need it it excel only.

Is there any option avaible?

Re: option to increase number of rows from Export

ShivamKS — Fri, 22 Jan 2016 10:48:45 GMT

You can try adjusting the va.SortResultServerLimit property in SAS SMC. This however might affect resuts only in List Tables.

Re: option to increase number of rows from Export

ArpanGhosh1 — Fri, 22 Jan 2016 11:07:29 GMT

I guess we need to restart LASR serevr after the modification