topic How to run a sample of data from a datajob in dm studio in SAS Data Management

How to run a sample of data from a datajob in dm studio

beamer108 — Thu, 08 Apr 2021 14:43:32 GMT

I have a long running datajob that I am testing and each time I make a change to the code I need to run the job to see if my changes worked. Is there a way to run the job but only get a sample of the data to help speed up the time its taking me to develop and test this job?

Re: How to run a sample of data from a datajob in dm studio

audrey — Thu, 08 Apr 2021 15:46:30 GMT

Hi,

There might be 2 things you can use:

- Previewing the node which can be done by Right-click > Preview (also use F6)

- Changing the MAX_OUTPUT_ROWS for your Input node: this will reduce the records read from the input database

Hope this helps.

Audrey

Re: How to run a sample of data from a datajob in dm studio

beamer108 — Thu, 08 Apr 2021 17:43:54 GMT

Thanks Audrey - I gave it a try and used 50 as my max output - unfortunately its still runs the full time as before.

Re: How to run a sample of data from a datajob in dm studio

audrey — Fri, 09 Apr 2021 07:15:45 GMT

Can you give a little more details about your job?

What nodes do you use, what data do you read, how long does it take to run?

Thanks.

Audrey