Mat India Technology Interview Questions and Answers

Use the OBS option in a SET statement to read the last observation of a SAS dataset.

• Use the OBS option in a SET statement followed by the keyword 'END' to read the last observation of a SAS dataset.

• For example, to read the last observation of a dataset named 'mydata', use the following code: data lastobs; set mydata(obs=last end=last); run;

Key Performance Indicators (KPIs) for Customer Lifetime Income (CLI) and Customer Lifetime Duration (CLD)

• CLI KPIs could include average revenue per customer, customer retention rate, customer lifetime value

• CLD KPIs could include average customer lifespan, customer churn rate, customer engagement metrics

• Tracking CLI and CLD KPIs can help measure the financial impact and longevity of customer relationships

Credit score variables impact strategy by influencing lending decisions and interest rates.

• Credit score variables include payment history, credit utilization, length of credit history, types of credit used, and new credit accounts.

• Higher credit scores typically result in lower interest rates and more favorable lending terms.

• Lenders use credit scores to assess risk and determine the likelihood of repayment.

• Strategies ma...read more

To find date difference in SAS, use INTCK function. To remove spaces from a string, use COMPRESS function.

• To find date difference, use INTCK function with appropriate interval (e.g. 'day', 'week', 'month')

• Example: date_diff = INTCK('day', start_date, end_date);

• To remove spaces from a string, use COMPRESS function with 'k' modifier

• Example: clean_string = COMPRESS(original_string, 'k');

Revolver and transactor are terms used in finance to describe different types of credit card users.

• Revolver is someone who carries a balance on their credit card and pays interest on it, while a transactor pays off their balance in full each month.

• Revolver users typically incur more interest charges over time, while transactors avoid paying interest by paying off their balance.

• Revolver users may benefit from rewards pr...read more