BookmarkSubscribeRSS Feed
ArpanGhosh1
Obsidian | Level 7

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

4 REPLIES 4
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

ArpanGhosh1
Obsidian | Level 7

We need it it excel only.

 

Is there any option avaible? 

ShivamKS
Obsidian | Level 7

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

ArpanGhosh1
Obsidian | Level 7

I guess we need to restart LASR serevr after the modification

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!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 2047 views
  • 0 likes
  • 3 in conversation