#Typical sas interview questions pdf how to#

Have you used ODS Statements? What are benefits of ODS?37. Which procedures will help me find it?36. I am trying to find the ways to find outliers in data. What is PROC FREQs default behavior for handling missing values?35. Do you know about the SAS autoexec file? What is its significance?33. What system option determines whether the macro facility searches a specific catalog for a stored, compiled macro?32. Give example of macro quoting functions?31. Which gets applied first when using the keep= and rename= data set options on the same data set?30. How would you code a macro statement to produce information on the SAS log?27. What option in PROC FORMAT allows you to create a format from an input control data set rather than VALUE statement?26. Have you used Call symputx ? What points need to be kept in mind when using it?25. Give some differences between PROC MEANS and PROC SUMMARY?24. What system options are you familiar with?22. State some differences between the DATA Step and SQL?21. Describe the ways in which you can create macro variables?20. Name atleast five compile time statements?18. If you use a SYMPUT in a DATA step, when and where can you use the macro variable?17.

#Typical sas interview questions pdf how to#

What is auto call macro and how to create a auto call macro? What is the use of it?16. What is the difference between %LOCAL and %GLOBAL?15. How would you determine the number of missing or nonmissing values in computations?14. What is the Program Data Vector (PDV)? What are its functions?12. How would you delete duplicate observations?11.

What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?10. Identify statements whose placement in the DATA step is critical.9. For what purposes do you use DATA _NULL_?8. It is possible to use the MERGE statement without a BY statement? Explain?6. Can you state some special input delimiters?5. Describe your familiarity with SAS Formats / Informats.4. What does the difference between combining 2 datasets using multiple SET statement and MERGE statement?ДЈ. What version of SAS are you currently using?Дў.