You havent told us anything about the dataset you are exporting, how your exporting etc. The size of the Excel file is controlled by the Excel file format, and the size of data your exporting. Not much you can do about that. Have you tried exporting to Comma Seperated Variable file? That can be opened in Excel, but is smaller file size (for bigger files). However again, it depends on the data your exporting, Excel is not a data transfer/database or a tool for most jobs and it has limitations on the size of data it can handle. 120mb is large for an Excel file, what are you going to do with it, nobody is ever going to look at a file that big. If its to transfer data then use a data transfer format (CSV, XML, dataset), if its for review then summarise the data.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.