Exploring, modeling, 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

Esteemed Advisor
Esteemed Advisor
Posts: 6,692

Re: option to increase number of rows from Export

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: 14

Re: option to increase number of rows from Export

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

Post a Question
Discussion Stats
  • 4 replies
  • 374 views
  • 0 likes
  • 3 in conversation