Desktop productivity for business analysts and programmers

Large SAS Jobs for Performance Testing

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 148
Accepted Solution

Large SAS Jobs for Performance Testing

Please can someone help me with a couple of sample sas jobs which can you use 200-300 MB and other job like 20-25 GB of data.

I need them for performance testing,am not good at programming.

It would be a big help to me if someone can share withe me.

 

 

 

Thanks

Swati

 

 


Accepted Solutions
Solution
‎05-23-2016 12:59 AM
Trusted Advisor
Posts: 1,054

Re: Large SAS Jobs for Performance Testing

Hi

 

The program I included will create about 250MB of data. That's on the basis of creating 25 variables, each variable takes 8 bytes, so it's around 200 bytes of data per record. The do loop repeats 1.25 million times, so that's how you get to 250MB.

 

If you write the data to a permanent library, you can check the size.

 

To get the 25 GB of data, just increase the number of times the loop runs by a factor of 100.

 

Tom

View solution in original post


All Replies
Esteemed Advisor
Posts: 5,198

Re: Large SAS Jobs for Performance Testing

So do you have the data already but need SAS programs?
Either way, performance testing is a very open field. What do you bed to test and why?
You need some non functional requirements to compare with your test results.
Data never sleeps
Frequent Contributor
Posts: 148

Re: Large SAS Jobs for Performance Testing

Thanks for reply...I don't have data...I need sample data also if possible along with programs.actually I need to do performance testing on our legacy systems Vs the new upgraded system.so that's why I need those programs.
Trusted Advisor
Posts: 1,054

Re: Large SAS Jobs for Performance Testing

Here's a quick program that will generate around 250MB of random data. If you want to up it to 25 GB just make the "do" statement

do count = 1 to 125000000;

 

data Test250MB;

do count = 1 to 1250000;

a = rand('uniform');

b = rand('uniform');

c = rand('uniform');

d = rand('uniform');

e = rand('uniform');

f = rand('uniform');

g = rand('uniform');

h = rand('uniform');

i = rand('uniform');

j = rand('uniform');

k = rand('uniform');

l = rand('uniform');

m = rand('uniform');

n = rand('uniform');

o = rand('uniform');

p = rand('uniform');

q = rand('uniform');

r = rand('uniform');

s = rand('uniform');

t = rand('uniform');

u = rand('uniform');

v = rand('uniform');

w = rand('uniform');

x = rand('uniform');

output;

end;

run;

 

Frequent Contributor
Posts: 148

Re: Large SAS Jobs for Performance Testing

Thank you very much Tomkari for the solution,I truly appreciate that.

 

so can i use this  program for performance testing without any changes to the code or do i still still need to make any changes.

and I beleive the below do count = 1 to 1250000 Is not 250 MB  right.

Its 1.25 GB right if am not wrong.

 

am looking for 250 MB and 25 GB data.

 

data Test250MB;

do count = 1 to 1250000;

a = rand('uniform');

b = rand('uniform');

c = rand('uniform');

d = rand('uniform');

e = rand('uniform');

f = rand('uniform');

g = rand('uniform');

h = rand('uniform');

i = rand('uniform');

j = rand('uniform');

k = rand('uniform');

l = rand('uniform');

m = rand('uniform');

n = rand('uniform');

o = rand('uniform');

p = rand('uniform');

q = rand('uniform');

r = rand('uniform');

s = rand('uniform');

t = rand('uniform');

u = rand('uniform');

v = rand('uniform');

w = rand('uniform');

x = rand('uniform');

output;

end;

run;

 

Solution
‎05-23-2016 12:59 AM
Trusted Advisor
Posts: 1,054

Re: Large SAS Jobs for Performance Testing

Hi

 

The program I included will create about 250MB of data. That's on the basis of creating 25 variables, each variable takes 8 bytes, so it's around 200 bytes of data per record. The do loop repeats 1.25 million times, so that's how you get to 250MB.

 

If you write the data to a permanent library, you can check the size.

 

To get the 25 GB of data, just increase the number of times the loop runs by a factor of 100.

 

Tom

Frequent Contributor
Posts: 148

Re: Large SAS Jobs for Performance Testing

Tomkari Tons of Thanks to you for the clarification and the solution

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 428 views
  • 0 likes
  • 3 in conversation