Add office photos
Filter interviews by
Merck Statistical Programmer Interview Questions, Process, and Tips
Top Merck Statistical Programmer Interview Questions and Answers
- Q1. proc report/ which argument should be used to modify variables
- Q2. What is the difference between where and if
- Q3. what is proc transpose/ what does the by do
Merck Statistical Programmer Interview Experiences
2 interviews found
Jacey Chai
I applied via LinkedIn and was interviewed in Feb 2024. There was 1 interview round.
(5 Questions)
- 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...
- 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
- 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...
- 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(
- 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...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Recruitment Consulltant and was interviewed in Sep 2023. There was 1 interview round.
(1 Question)
- 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...
Interview questions from similar companies
Selected
I applied via LinkedIn and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. Introduction about myself and the position
- Q2. When can start the work
Interview Preparation Tips
(2 Questions)
- Q1. Difference between mean in data step and proc means
- Ans.
Mean in data step calculates mean within data step while proc means calculates mean for entire dataset.
Mean in data step is calculated within the data step and only for the variables specified in the data step.
Proc means calculates mean for the entire dataset or for the variables specified in the var statement.
Data step mean can be used for conditional calculations while proc means is used for overall summary statistic
- Q2. Data step is used to find out means for row where as proc means for columns
Interview Preparation Tips
I applied via Referral and was interviewed before May 2023. There was 1 interview round.
(3 Questions)
- Q1. Write SAS code - 1. how will you create and correctly sort multiple Unscheduled visits & Planned visits 2. Data- names and ages- Flag highest and lowest age
- Ans.
Creating and sorting multiple visits in SAS, flagging highest and lowest age
Use PROC SORT to sort the data by visit type (Unscheduled vs Planned) and age
Use PROC RANK to flag the highest and lowest age
Consider using IF-THEN statements to identify and flag the highest and lowest age
- Q2. What is RELREC. How will you create it ?
- Ans.
RELREC stands for Relative Record Number. It is a unique identifier assigned to each record in a dataset.
RELREC is used to uniquely identify each record in a dataset.
It is typically created by assigning a sequential number to each record as it is added to the dataset.
For example, the first record added to a dataset would have a RELREC of 1, the second record would have a RELREC of 2, and so on.
- Q3. How will you merge SUPPPQUAL with parent domain
- Ans.
Merge SUPPPQUAL with parent domain by using common identifiers and joining the datasets.
Identify common identifiers between SUPPPQUAL and parent domain
Use a join operation to merge the datasets based on the common identifiers
Ensure data integrity and consistency after merging
Skills evaluated in this interview
Selected
I was interviewed before Nov 2023.
(2 Questions)
- Q1. Situation given we had to write code in R to solve that
- Q2. Questions asked about the project we finished in last company
(1 Question)
- Q1. Similar to round 1
Statistician Interview Questions & Answers
GlaxoSmithKline Pharmaceuticals
Anonymous
posted on 26 Oct 2022
I applied via Company Website and was interviewed before Oct 2021. There were 3 interview rounds.
(1 Question)
- Q1. Basic clinical trial questions. Basic Statistics. Experience on project.
(1 Question)
- Q1. Basic strength and weekness , pressure questions.
Interview Preparation Tips
Selected
I applied via LinkedIn and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. Introduction about myself and the position
- Q2. When can start the work
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed before Nov 2021. There were 3 interview rounds.
(2 Questions)
- Q1. Interview with operational manager with no SAS skill.
- Q2. Chat on previous working experience.
(2 Questions)
- Q1. Technical interview with functional manager.
- Q2. Difference between where and if. Ways to debug macros. Few questions on statistics e.g. multiple pairwise comparison adjustments.
Interview Preparation Tips
- SAS/STAT
- SAS Base
Statistical Analyst Interview Questions & Answers
Eli Lilly and Company
Anonymous
posted on 26 Aug 2023
Selected
I applied via campus placement at Institute of Bioinformatics & Applied Biotechnology, Bangalore and was interviewed before Aug 2022. There were 3 interview rounds.
Mental maths and english assessment
(1 Question)
- Q1. Questions on R such as least fit square method . Anova and statistical questions
Merck Interview FAQs
Tell us how to improve this page.
Merck Interviews By Designations
- Merck Data Analyst Interview Questions
- Merck Statistical Programmer Interview Questions
- Merck Therapy Manager Interview Questions
- Merck Assistant Store Manager Interview Questions
- Merck Associate Systems Engineer Interview Questions
- Merck Business Analyst Interview Questions
- Merck Intern Interview Questions
- Merck Pricing Specialist Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Statistical Programmer Interview Questions
- Statistical Analyst Interview Questions
- Statistician Interview Questions
- Staff Nurse Interview Questions
- Research Associate Interview Questions
- Medical Coder Interview Questions
- Pharmacist Interview Questions
- Lab Technician Interview Questions
- Show more
People are getting interviews through
Interview Questions from Similar Companies
|
Senior Analyst
137
salaries
|  ₹5.5 L/yr - ₹23 L/yr |
|
Analyst
62
salaries
| ₹3 L/yr - ₹10.5 L/yr |
|
Specialist
38
salaries
| ₹4.7 L/yr - ₹13 L/yr |
|
Manager
36
salaries
| ₹11.9 L/yr - ₹33 L/yr |
|
System Engineer
36
salaries
| ₹4 L/yr - ₹8.3 L/yr |
Pfizer
GlaxoSmithKline Pharmaceuticals
Novartis
Johnson & Johnson
Calculate your in-hand salary
- Home >
- Interviews >
- Merck Interview Questions >
- Merck Statistical Programmer Interview Questions
