Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

option to increase number of rows from Export

Reply
Occasional Contributor
Posts: 11

option to increase number of rows from Export

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

Super User
Super User
Posts: 9,862

Re: option to increase number of rows from Export

Posted in reply to ArpanGhosh1

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.

Occasional Contributor
Posts: 11

Re: option to increase number of rows from Export

We need it it excel only.

 

Is there any option avaible? 

Occasional Contributor
Posts: 15

Re: option to increase number of rows from Export

Posted in reply to ArpanGhosh1

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

Occasional Contributor
Posts: 11

Re: option to increase number of rows from Export

I guess we need to restart LASR serevr after the modification

Ask a Question
Discussion stats
  • 4 replies
  • 593 views
  • 0 likes
  • 3 in conversation