Acuity Knowledge Partners Senior Analyst Interview Questions and Answers

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

Q1. Explan PV Ratio and difference between accrual and prepaid expense.
Ans. 
PV ratio is the ratio of contribution to sales. Accrual expenses are recognized but not yet paid, while prepaid expenses are paid but not yet recognized.
• PV ratio is calculated by dividing contribution by sales.

• It helps in determining the break-even point and the impact of changes in sales volume on profit.

• Accrual expenses are expenses that have been incurred but not yet paid, such as salaries or interest.

• Prepaid expens...read more
Answered by AI
View 1 more answer

Q1. Journal entries related to sales return and accounts payable.
Add your answer

Brand Management

Q1. What is esg? What is annual report
Ans. 
ESG stands for Environmental, Social, and Governance. Annual report is a comprehensive report on a company's activities throughout the preceding year.
• ESG refers to the three central factors in measuring the sustainability and ethical impact of an investment in a company or business.

• Environmental factors include a company's impact on the environment, such as carbon emissions and waste management.

• Social factors include a...read more
Answered by AI
Add your answer
Q2. Where do you see yourself in next 5 years?
Add your answer
Q3. Thats it. Nothing more
Add your answer