EXL Service Business Analyst Interview Questions, Process, and Tips

Q1. SQL, tableau questions
Add your answer

Q1. Work related questions. Only few questions
Add your answer
Q2. Previous work, salary expectation, why do you want to change the job
Add your answer

Q1. Difference between proc means and proc summary?
Ans. 
Proc means and proc summary are SAS procedures used for summarizing data, but with slight differences.
• Proc means provides more detailed statistics like standard deviation, minimum and maximum values, while proc summary only provides basic statistics like mean and sum.

• Proc means can handle missing values, while proc summary cannot.

• Proc summary can create multiple output datasets, while proc means only creates one.

• Both p...read more
Answered by AI
Add your answer
Q2. Elaborate PDV in SAS
Ans. 
PDV in SAS stands for Program Data Vector, which is a temporary storage area for data during program execution.
• PDV is used to hold data values during program execution

• It is created automatically by SAS and is used to store data temporarily

• PDV is used to hold data values before they are written to a SAS dataset

• It is also used to hold data values during data manipulation and analysis
Answered by AI
Add your answer

Scenario based problems on Proc SQL, date functions, data dictionary, macros etc