topic Re: Large SAS Jobs for Performance Testing in SAS Enterprise Guide

Large SAS Jobs for Performance Testing

sasprofile — Sun, 22 May 2016 02:23:04 GMT

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

Re: Large SAS Jobs for Performance Testing

LinusH — Sun, 22 May 2016 06:47:28 GMT

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.

Re: Large SAS Jobs for Performance Testing

sasprofile — Sun, 22 May 2016 15:14:55 GMT

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.

Re: Large SAS Jobs for Performance Testing

TomKari — Sun, 22 May 2016 15:22:24 GMT

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;

Re: Large SAS Jobs for Performance Testing

sasprofile — Sun, 22 May 2016 23:51:23 GMT

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;

Re: Large SAS Jobs for Performance Testing

TomKari — Mon, 23 May 2016 01:13:23 GMT

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

Re: Large SAS Jobs for Performance Testing

sasprofile — Mon, 23 May 2016 04:59:11 GMT

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