Volume of network traffic? By time of day?
Size of data set, number of records and number of variables used
Specific "procedures" involved
Type of output generated
Disk space used, disk speed
A brief list of things that will impact run time.
If the code is debugged and runs routinely I would suggest running this a batch job when use of resources like the network is low.
Space, especially user work space, on disks and computer may have a significant impact on run time. If memory use is maxed out then SAS spends a lot of time writing temporary information to disk and then reading it back for the operation.
Look at your logs and see which steps are taking the most time. That code may be a target for reducing run time.
As far as I know, SAS does not have a way to predict execution time, so I think the only way is to run it using a sample data set with extracted data, as Reeza said.
However, since the procedure is often not simply proportional to the dataset size, I think you need to measure the data step and proc step separately to improve the accuracy of the estimation.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.