Rohit Surgical Interview Questions and Answers

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 programs or cash back offers, while transactors may not maxi...read more

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;

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 may involve targeting specific credit score ranges for diffe...read more

Metrics such as mean, median, mode, standard deviation, and range can be useful in analyzing a defined dataset.

• Mean: average value of the dataset

• Median: middle value of the dataset when arranged in ascending order

• Mode: most frequently occurring value in the dataset

• Standard deviation: measure of the amount of variation or dispersion of a set of values

• Range: the difference between the maximum and minimum values in the dataset

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