Merck Interview Questions, Process, and Tips

Q1. What is the difference between where and if
Ans. 
The main difference between 'where' and 'if' is that 'where' is used for filtering data in SQL queries, while 'if' is used for conditional statements in programming languages.
• WHERE clause is used in SQL to filter rows based on a specified condition, while IF statement is used in programming languages to execute a block of code based on a condition.

• WHERE clause is used with SELECT, UPDATE, DELETE statements in SQL, whil...read more
Answered by AI
Add your answer
Q2. What is the difference between sum and +
Ans. 
Sum is a function that calculates the total of a set of numbers, while + is an operator that adds two numbers together.
• Sum is a built-in function in many programming languages that calculates the total of a set of numbers.

• + is an operator used to add two numbers together in mathematical operations.

• Example: sum(1, 2, 3) = 6, 1 + 2 = 3
Answered by AI
Add your answer
Q3. What is proc transpose/ what does the by do
Ans. 
Proc transpose is a SAS procedure used to restructure data from a long format to a wide format.
• Proc transpose is used to pivot data from rows to columns or vice versa.

• The BY statement in proc transpose is used to specify one or more variables that define groups in the input data.

• The BY statement is optional and is used to create separate output datasets for each BY group.

• Example: proc transpose data=input_data out=outp...read more
Answered by AI
Add your answer
Q4. Proc report/ which argument should be used to modify variables
Ans. 
The argument used to modify variables in proc report is 'define'.
• Use the 'define' statement in proc report to modify variables.

• The 'define' statement allows you to customize the appearance and behavior of variables in the report.

• You can use options like 'format', 'order', 'width', 'style', etc. within the 'define' statement.

• Example: define age / display format=comma10. order=data;

• Example: define gender / display style(
Answered by AI
Add your answer
Q5. What is data step and what is proc step
Ans. 
Data step is used to read, manipulate, and create datasets in SAS. Proc step is used to analyze and report on datasets.
• Data step is used to read data from external sources, manipulate data, and create new datasets.

• Proc step is used to analyze and report on datasets created in the data step.

• Data step uses statements like SET, MERGE, IF-THEN, and OUTPUT to manipulate data.

• Proc step uses procedures like PROC MEANS, PROC F...read more
Answered by AI
Add your answer

Q1. Resume related questions
Add your answer
Q2. Erp related experience
Add your answer

They will give a topic on the spot we need to talk about it

Q1. They give some issue we need to answer what trouble shooting we have to perform
Add your answer

Q1. About projects and achievements
Add your answer

Q1. What is BODS ?
Ans. 
BODS stands for Business Objects Data Services, a data integration tool by SAP for ETL processes.
• BODS is used for extracting, transforming, and loading data between different systems.

• It can connect to various data sources like databases, applications, and files.

• BODS allows for data quality management, data profiling, and metadata management.

• It is commonly used for data migration, data warehousing, and data synchronizat...read more
Answered by AI
Add your answer
Q2. Why you are using BODS?
Ans. 
I am using BODS for data integration, transformation, and loading tasks in SAP environments.
• Efficiently integrates data from various sources

• Transforms data to meet business requirements

• Loads data into SAP systems for analysis and reporting
Answered by AI
Add your answer

It was a 90 mins round, and we have to do 85 questions. Coding was also a part of it.

Q1. Firstly HR called and asked me if i was available on a certain day for interview when i went ahead to check my calendar she told me that if i am interested in job i have to be available for that specific t...read more
Add your answer

Q1. Why you wanna change current organization
Add your answer
Q2. How you will add value to organization
Add your answer

About your situation handling

Q1. Whats expectation in CTC
Ans. 
Expectations in CTC refer to the salary package and benefits that an employee anticipates receiving from the organization.
• CTC includes salary, bonuses, benefits, and perks offered by the employer.

• Employees expect a competitive CTC package based on their qualifications and experience.

• CTC may also include allowances, insurance coverage, and other financial incentives.

• Expectations in CTC can vary based on industry standar
Answered by AI
Add your answer