Know How:BusinessIntelligence:SAS:Allgemeines
Aus Ralph's Wiki
|
Hauptseite > Know How > Business Intelligence > SAS > Allgemeines | ||||||||||||||||||
|
Inhaltsverzeichnis |
Allgemeines
Tests
Basic Questions
Original Questions are here: [[1]]
- What is the effect of the OPTIONS statement ERRORS=1?
- What’s the difference between VAR A1 - A4 and VAR A1 — A4?
- What do the SAS log messages "numeric values have been converted to character" mean? What are the implications?
- Why is a STOP statement needed for the POINT= option on a SET statement?
- How do you control the number of observations and/or variables read or written?
- Approximately what date is represented by the SAS date value of 730?
- How would you remove a format that has been permanently associated with a variable??
- What does the RUN statement do?
- Why is SAS considered self-documenting?
- What areas of SAS are you most interested in?
- Briefly describe 5 ways to do a "table lookup" in SAS.
- What versions of SAS have you used (on which platforms)?
- What are some good SAS programming practices for processing very large data sets?
- What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?
- How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?
- What is the different between functions and PROCs that calculate the same simple descriptive statistics?
- If you were told to create many records from one record, show how you would do this using arrays and with PROC TRANSPOSE?
- What are _numeric_ and _character_ and what do they do?
- How would you create multiple observations from a single observation?
- For what purpose would you use the RETAIN statement?
- What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
- What is the order of application for output data set options, input data set options and SAS statements?
- What is the order of evaluation of the comparison operators: + - * / ** ( ) ?
- How could you generate test data with no input data?
- How do you debug and test your SAS programs?
- What can you learn from the SAS log when debugging?
- What is the purpose of _error_?
- How can you put a "trace" in your program?
- Are you sensitive to code walk-throughs, peer review, or QC review?
- Have you ever used the SAS Debugger?
- What other SAS features do you use for error trapping and data validation?
- How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
- How many missing values are available? When might you use them?
- . How do you test for missing values?
- . How are numeric and character missing values represented internally?
Advanved Questions
- Describe the types of SAS programming tasks that you performed: Tables? Listings? Graphics? Ad hoc reports? Other?
- Have you been involved in editing the data or writing data queries?
- What techniques and/or PROCs do you use for tables?
- Do you prefer PROC REPORT or PROC TABULATE? Why?
- Are you involved in writing the inferential analysis plan? Tables specifications?
- What do you feel about hardcoding?
- How experienced are you with customized reporting and use of DATA _NULL_ features?
- How do you write a test plan?
- What is the difference between verification and validation?
- What was the last computer book you purchased? Why?
- What is your favorite all time computer book? Why?
- Will it bother you if the guy at the next desk times the frequency and duration of your bathroom/coffee breaks on the grounds that ‘you are getting paid twice as much as he is’?
- How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says: ‘hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book!’
- Can you continue to write code while the rest of the people on the floor where you work have a noisy party to which you were not invited?
- Can you start on Monday?
- Do you think professionally?
- How do you put a giraffe into the refrigerator? Correct answer: Open the refrigerator door, put the giraffe in, and close the door. This question tests whether or not the candidate is doing simple things in a complicated way.
- How do you put an elephant in the refrigerator? Incorrect answer: Open the refrigerator door, put in the elephant, and close the door. Correct answer: Open the refrigerator door, take out the giraffe, put in the elephant, and close the door. This question tests your foresight.
- The Lion King is hosting an animal conference. All the animals in the world attend except one. Which animal does not attend? Correct answer: The elephant. The elephant is in the refrigerator, remember? This tests if you are capable of comprehensive thinking.
- There is a river notoriously known for it’s large crocodile population. With ease, how do you safely cross it? Correct answer: Simply swim across. All of the crocodiles are attending the Lion King’s animal conference. This questions your reasoning ability.
- Describe a time when you were really stuck on a problem and how you solved it.
- Describe the function and utility of the most difficult SAS macro that you have written.
- Give me an example of ..
- Tell me how you dealt with …
- How do handle working under pressure?
- Of all your work, where have you been the most successful?
- What are the best/worst aspects of your current job?
- If you could design your ideal job, what would it look like?
- How necessary is it to be creative in your work?
- If money were no object, what would you like to do?
- What would you change about your job?
