Reference no: EM133306396
Complete the following questions and return responses to Wells Fargo in advance of the interview call:
Question 1: Describe how you would approach building and explaining when you have full data file that you have to exclude sections of the file for specifics reasons. High level approach to building it and best way to display visually the totals and exclusions.
Question 2: Describe an instance where you had to gather data from multiple data sources. What were the sources and what tools did you use to gather and analysis the data?
Question 3: Describe if given two data sets/tables that needed to be joined together but have no common field names how you would go about finding the common element to combine the data.
Question 4: Describe the key points you would consider and look at if reviewing a peer's code for accuracy.
Question 5: Describe a time when you were analyzing data and received an error code. What were you analyzing? What was the error? How did you resolve the error?
Question 6: Describe with code, how you would write a query to join table A and B on account number, keeping all records from table A and excluding records with marketing code = 8.
Question 7: Describe in layman's terms what the following code is doing:
o Select sum(z.check_amt), acct
o From table_1 z
o join table_2 x
o On z.acct = x.acct
o Group by acct .
• Using this same code if I wanted to keep all records in table X how could I do this using only one or two words to change it?
Question 8: Describe a time when you had to use a macro. What was the situation? How did you go about building the macro?
• If you were presenting a dataset that contained acct, price, dates, sales that you need to display visually the items sold by date and profit from each what type of visual would you use?
• If using excel to consolidate and summarize data to a specific data element, how would you do that?
• SAS specific questions
• Describe the difference between a SAS function and a procedure
• Can you name some of the functions and procedures you commonly use?
• Describe the most beneficial items in a SAS log and how you use them to assure accuracy?