BookmarkSubscribeRSS Feed
Shussa
Calcite | Level 5


Hi,

Is there a way to copy and paste transformations from one job to another?  I know you can copy the job but are there any options to copy the transformations (and input/output tables).

Cheers!

5 REPLIES 5
shivas
Pyrite | Level 9

Hi,

I am not able to understand copy and paste transformation.

If you want your job or input/output tables to copied then you can make .spk file and import where ever you want .

If the transformation is a generated transformation then you can specify your own path and transformation will be saved and you can use this by just drag and drop in your jobs.

Thanks,

Shiva

Shussa
Calcite | Level 5

Say I have a transformation in jobA with specefic options/parameters set. I want to copy the transformation to JobB.  I can drag the default transformation but will have to go through and set the parameters/options again.  Is there a way to copy the existing transformation in a job to another job so that it preserves the options/parameters/precode etc etc?

Hope thats clear.

Thanks,

LinusH
Tourmaline | Level 20

No, there are no direct way to copy parts of jobs into another job.

On way to do it is to copy the whole job, then delete the unwanted parts in the copied job.

If you have a part of job that is generic, or very similar between jobs, you might want to explore the possibilities to reuse the code in another way. This could be by isolate it to a job, which can be called from other jobs. Or, if you are using user written code, make a user written transform.

/Linus

Data never sleeps
andrea_monico
Calcite | Level 5

Hi, have you ever found a solution to your problem? I'd be quite interested to know the best way to proceed. Thanks

LinusH
Tourmaline | Level 20
This thread is three years old. Crate a new thread with your own specific requirements and constraints.
Given the answers to the OP the answer is still no since there haven't been any developments on the sw in this area since then.
Data never sleeps

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 1944 views
  • 0 likes
  • 4 in conversation