Hi,
I have a file with approximately 35,000 records and 77 variables. I was trying to resize one of the columns in the Output Data window and accidentally must have clicked on the Sort function in that column. Twenty minutes later, I'm still waiting for SAS EG to start functioning again.
What can I do to automatically size columns in the data viewer? Is there anything that can be done to speed searches for values in SAS EG? As it is, I export the data to Excel at a key point in the processing to search and modify records because EG is so incredibly slow.
Any help would be greatly appreciated!
Thanks,
Bryan
My preferred way of searching is to use the new WHERE statement option in EG 7.11 Data Viewer. This doesn't require sorting and performance is very good even on 1 million plus row tables. Result sets are selected and returned in under 20 seconds normally.
If you don't have EG 7.11 you can easily request this from SAS.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.