BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
sasprofile
Quartz | Level 8

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
TomKari
Onyx | Level 15

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

6 REPLIES 6
LinusH
Tourmaline | Level 20
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
sasprofile
Quartz | Level 8
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.
TomKari
Onyx | Level 15

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;

 

sasprofile
Quartz | Level 8

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;

 

TomKari
Onyx | Level 15

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

sasprofile
Quartz | Level 8

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

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.

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
  • 6 replies
  • 6369 views
  • 0 likes
  • 3 in conversation