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
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
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;
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;
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
Tomkari Tons of Thanks to you for the clarification and the solution
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.