1. What areas of SAS are you most interested in?
2. Describe 5 ways to do a "table lookup" in SAS.
3. What versions of SAS have you used (on which platforms)?
4. What are some good SAS programming practices for processing very large data sets?
5. What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?
6. How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?
7. What is the different between functions and PROCs that calculate the same simple descriptive statistics?
8. If you were told to create many records from one record, show how you would do this using array and with PROC TRANSPOSE?
9. What do the SAS log messages "numeric values have been converted to character" mean? What are the implications?
10. Why is a STOP statement needed for the POINT= option on a SET statement?
11. How do you control the number of observations and/or variables read or written?
12. Approximately what date is represented by the SAS date value of 730?
13. Identify statements whose placement in the DATA step is critical.
14. What does the RUN statement do?
15. Why is SAS considered self-documenting?
16. What are some good SAS programming practices for processing very large data sets?
17. What is the different between functions and PROCs that calculate thesame simple descriptive statistics?
18. If you were told to create many records from one record, show how you would do this using arrays and with PROC TRANSPOSE?
19. What is a method for assigning first.VAR and last.VAR to the BY groupvariable on unsorted data?
20. How do you debug and test your SAS programs?
21. What other SAS features do you use for error trapping and data validation?
22. How would you combine 3 or more tables with different structures?
23. What are _numeric_ and _character_ and what do they do?
24. For what purpose would you use the RETAIN statement?
25. How could you generate test data with no input data?
26. How do you debug and test your SAS programs?
27. What can you learn from the SAS log when debugging?
28. What is the purpose of _error_?
29. How do you test for missing values?
30. In the flow of DATA step processing, what is the first action in a typical DATA Step?
31. What are SAS/ACCESS and SAS/CONNECT?
32. What is the one statement to set the criteria of data that can be coded in any step?
33. What is the purpose of using the N=PS option?
34. What are the scrubbing procedures in SAS?
35. What are the new features included in the new version of SAS i.e., SAS9.1.3?
36. What do the PUT and INPUT functions do?
37. Which date function advances a date, time or datetime value by a given interval?
38. How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
39. In ARRAY processing, what does the DIM function do?
40. How would you determine the number of missing or nonmissing values in computations?
41. Do you need to know if there are any missing values?
42. What are the validation tools in SAS?
43. How can you put a "trace" in your program?
44. What are input dataset and output dataset options?
45. What is SAS GRAPH?
2. Describe 5 ways to do a "table lookup" in SAS.
3. What versions of SAS have you used (on which platforms)?
4. What are some good SAS programming practices for processing very large data sets?
5. What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?
6. How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?
7. What is the different between functions and PROCs that calculate the same simple descriptive statistics?
8. If you were told to create many records from one record, show how you would do this using array and with PROC TRANSPOSE?
9. What do the SAS log messages "numeric values have been converted to character" mean? What are the implications?
10. Why is a STOP statement needed for the POINT= option on a SET statement?
11. How do you control the number of observations and/or variables read or written?
12. Approximately what date is represented by the SAS date value of 730?
13. Identify statements whose placement in the DATA step is critical.
14. What does the RUN statement do?
15. Why is SAS considered self-documenting?
16. What are some good SAS programming practices for processing very large data sets?
17. What is the different between functions and PROCs that calculate thesame simple descriptive statistics?
18. If you were told to create many records from one record, show how you would do this using arrays and with PROC TRANSPOSE?
19. What is a method for assigning first.VAR and last.VAR to the BY groupvariable on unsorted data?
20. How do you debug and test your SAS programs?
21. What other SAS features do you use for error trapping and data validation?
22. How would you combine 3 or more tables with different structures?
23. What are _numeric_ and _character_ and what do they do?
24. For what purpose would you use the RETAIN statement?
25. How could you generate test data with no input data?
26. How do you debug and test your SAS programs?
27. What can you learn from the SAS log when debugging?
28. What is the purpose of _error_?
29. How do you test for missing values?
30. In the flow of DATA step processing, what is the first action in a typical DATA Step?
31. What are SAS/ACCESS and SAS/CONNECT?
32. What is the one statement to set the criteria of data that can be coded in any step?
33. What is the purpose of using the N=PS option?
34. What are the scrubbing procedures in SAS?
35. What are the new features included in the new version of SAS i.e., SAS9.1.3?
36. What do the PUT and INPUT functions do?
37. Which date function advances a date, time or datetime value by a given interval?
38. How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
39. In ARRAY processing, what does the DIM function do?
40. How would you determine the number of missing or nonmissing values in computations?
41. Do you need to know if there are any missing values?
42. What are the validation tools in SAS?
43. How can you put a "trace" in your program?
44. What are input dataset and output dataset options?
45. What is SAS GRAPH?
No comments:
Post a Comment