Data Mining Specialist Interview Questions

372 data mining specialist interview questions shared by candidates

1 - As a Researcher what are the ways through which you can retrieve Unique records in SAS data set Answer: NO Dupkey (As Unique means something which is not repeated) 2 - As a Researcher you have been assigned a task of merging two separate data sets . What is the most important condition which has to be kept in mind for merging two separate dataz using a command Proc Merge. Answer: There is no such command known as proc merge as merging can only be done in a data step and not in Proc step 3 - What is the most important statement in a data step whose placement is very critical? Answer: Length statement as it has to be placed on top so that length of characters can be taken. If you give a length statement in the bottom then length of characters will not come. 4 - There is a data which has 500 observations and you only have to research on Observations from 27 to 45 so what command will you use? Answer: is Use of Conditions in combination with _n_ as its an automatic variable & question specifies Data has 500 observations and you shall specify if 27 greater than equal to _N_ and less than equal to 45 . & also can be done by 1st Obs & last Obs. 5 - As a researcher can u also use a substring function to read data from Left to Right ? Correct Answer: Only Scan can be used 6 - Why is a sum function preferred over a + operator..? Correct Answer Function shall consider the Missing value as zero and give the answer whereas + operator shall not give answer 7 - If you were given several SAS data sets you were unfamiliar with, how would you find out the variable names and formats of each dataset? Correct Answer: is Proc contents 8 - How do you remove only the trailing Blanks in SAS (Trailing Blanks mean blanks which are one after the other)? Answer: Its through COMP BL command it is compress and keep the Blank 9 - what items are created while processing any Data in sas? Correct Answer - Observation & Variables
avatar

SAS Financial Data Mining - (Financial Research Analyst)

Interviewed at Optus Research & Analytics

4
Jan 19, 2023

1 - As a Researcher what are the ways through which you can retrieve Unique records in SAS data set Answer: NO Dupkey (As Unique means something which is not repeated) 2 - As a Researcher you have been assigned a task of merging two separate data sets . What is the most important condition which has to be kept in mind for merging two separate dataz using a command Proc Merge. Answer: There is no such command known as proc merge as merging can only be done in a data step and not in Proc step 3 - What is the most important statement in a data step whose placement is very critical? Answer: Length statement as it has to be placed on top so that length of characters can be taken. If you give a length statement in the bottom then length of characters will not come. 4 - There is a data which has 500 observations and you only have to research on Observations from 27 to 45 so what command will you use? Answer: is Use of Conditions in combination with _n_ as its an automatic variable & question specifies Data has 500 observations and you shall specify if 27 greater than equal to _N_ and less than equal to 45 . & also can be done by 1st Obs & last Obs. 5 - As a researcher can u also use a substring function to read data from Left to Right ? Correct Answer: Only Scan can be used 6 - Why is a sum function preferred over a + operator..? Correct Answer Function shall consider the Missing value as zero and give the answer whereas + operator shall not give answer 7 - If you were given several SAS data sets you were unfamiliar with, how would you find out the variable names and formats of each dataset? Correct Answer: is Proc contents 8 - How do you remove only the trailing Blanks in SAS (Trailing Blanks mean blanks which are one after the other)? Answer: Its through COMP BL command it is compress and keep the Blank 9 - what items are created while processing any Data in sas? Correct Answer - Observation & Variables

Viewing 91 - 100 interview questions

Glassdoor has 372 interview questions and reports from Data mining specialist interviews. Prepare for your interview. Get hired. Love your job.