BookmarkSubscribeRSS Feed
BrahmanandaRao
Lapis Lazuli | Level 10
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
4 REPLIES 4
Reeza
Super User
Run it on a smaller samples and extrapolate.
ballardw
Super User

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.

 

 

BrahmanandaRao
Lapis Lazuli | Level 10
my question is how to estimate executiion time before run the code
japelin
Rhodochrosite | Level 12

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.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 684 views
  • 3 likes
  • 4 in conversation