topic Estimate excution time in SAS Programming

Estimate excution time

BrahmanandaRao — Thu, 11 Feb 2021 16:25:30 GMT

Suppose i have code datastep and procedure it could be take 5 hours
To excute output so how can we estimate execution time before we run the program

Re: Estimate excution time

Reeza — Thu, 11 Feb 2021 16:42:39 GMT

Run it on a smaller samples and extrapolate.

Re: Estimate excution time

ballardw — Thu, 11 Feb 2021 17:00:33 GMT

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.

Re: Estimate excution time

BrahmanandaRao — Fri, 12 Feb 2021 15:06:51 GMT

my question is how to estimate executiion time before run the code

Re: Estimate excution time

japelin — Fri, 12 Feb 2021 15:20:40 GMT

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.