Monday, March 23, 2015

ETL Job via SAS DI Studio:Why Precode and Postcode properties of a job is disabled?

If you are an ETL developer and working with the tool called SAS DI Studio. A bad day in the morning could be started like; you are not able to insert code in the Precode and Postcode box of your job properties. The check box for Precode and Postcode is disabled. It's maybe nonsense, you never seen this kind of error before, right??!! Precode and Postcode of the job property look like below:

                       Fig 1: Precode and Postcode of the Job Property is disabled.

What Can go wrong?

If you look at the below picture, you will find three different type of code generation mode.

                         Fig 2: Three different type of Code generation mode

Generally Code generation mode 'Automatic' is selected by default.

                                        Fig 3: By default 'automatic' is selected.

If we want to look at the user defined code then usually we select 'All user Written' which is look like below:
                                    Fig 4: Code generation mode 'All user written' selected.

By mistakenly, if you choose 'all user written' and click 'yes' (see below image) then code generation mode will be changed and saved.

                                Fig 5:Saving code generation mode 'All user written'.

At this situation, if you click on properties and want to insert Precode and Postcode for the job, you will not be able add Precode and Postcode for the job. The option is disable for the job.

How you can Enable Precode and Poscode?

To enable Precode and Postcode we need to change code generation mode from 'All user written' to 'Automatic' and save it.

Then you will be able to add Precode and Postcode in the job and property screen will look like below:

                                        Fig 6: Enabled Precode and Postcode


Clinnovo said...

This blog gives very important info about SAS Thanks for sharing.Very well written information. Many

SAS training
SAS course
SAS Certification
SAS Certification course
Online SAS Training

high technologies solutions said...

helpful post
sas training in delhi
sas training in noida

Clinnovo said...

Clinnovo Research Labs provides Internships, Trainings, Job Assistance in the Domains of Clinical Research, Clinical Data Management, SAS, Pharmacovigilance. For more details contact us @ +91-9985492233.

SAS training
Online Pharmacovigilance course
class room pharmacovilance training
SDTM Training
ADAM Training
clinical Research Training
clinical data management Training

High Technologies Solutions said...

I read Your Post & really it is very Nice and Informative Post... Thanks for Sharing & Keep Doing Otherwise If anyone Want to Learn Data analytics Training with Adv. Level So You Can click below

Certified SAS Training Center with Placements offer also

sas training institute in delhi
sas training institute in Noida

priya said...

Pharmacovigilance is a branch of the pharmacy where vigilance is kept over the use of drugs. According to WHO guidelines, proper reporting of Adverse drug reactions, and Adverse events is necessary in order to completely justify the job of Pharmacovigilance. At present career in it is at boom and various institutes provide Pharmacovigilance courses.

regulatory affairs courses in pune
clinical research and pharmacovigilance courses
masters in clinical research
masters in clinical trial management

pharmacovigilance courses in pune
Diploma in pharmacovigilance course in pune

clinical research courses in pune
clinical research institute in pune
Diploma in clinical research
Diploma in advanced clinical research