SAS Interview Questions You'll Most Likely Be Asked

Vibrant Publishers

• Publisher: Vibrant Publishers
• Year: 2019
• eBook ISBN: 9781949395136
• Edition: 1
• Topic: Computer Science
• Subtopic: Computer Science General
• Index: Computer Science

· 645 SAS Interview Questions

· 113 HR Interview Questions

· Real life scenario based questions

· Strategies to respond to interview questions

· 2 Aptitude Tests

SAS Interview Questions You'll Most Likely Be Asked is designed to include all the possible SAS interview questions that exist. This book includes 215 SAS Programming Guidelines, 215 Base SAS and 215 Advanced SAS interview questions along with detailed answers and proven strategies for getting hired as an IT professional. Apart from the technical questions, this value pack includes 113 Human Resource interview questions to give impressive answers that help nail the job interview. All this makes it a complete value-for-money purchase.

The following is included in this book:

a) 645 SAS Interview Questions, Answers and proven strategies for getting hired as an IT professional

b) Dozens of examples to respond to interview questions

c) 113 HR Questions with Answers and proven strategies to give specific, impressive, answers that help nail the interviews

d) 2 Aptitude Tests download available on https://www.vibrantpublishers.com

INDEX

SAS Interview Questions

SAS Programming Guidelines

Efficient SAS Programming

1: How do you achieve scalability in SAS programming?

2: How do SQL Views help better efficiency?

3: What do you know about the SPD Engine?

4: What resources are used to run a SAS program?

5: List the factors that need to be considered while assessing the technical environment.

6: Explain the functionality of the system option STIMER in the Windows environment.

7: What is the function of the option FULLSTIMER in the Windows operating environment?

8: Explain the MEMRPT option.

9: While benchmarking the programming techniques in SAS, why is it necessary to execute each programming technique in separate sessions?

10: While doing benchmark tests, when is it advisable to run the code for each programming technique several times?

11: How do you turn off the FULLSTIMER option?

12: What steps can be taken to reduce the programmer time?

Memory Usage

13: What is PDV? How does it work?

14: How would you choose between DATA step and PROC SQL?

15: Explain memory management in SAS.

16: What is the sequence of actions performed in the background while trying to create a data set from another data set?

17: Define PAGE and PAGESIZE.

18: What procedure is used to indicate the PAGESIZE of a data set?

19: Is it possible to control the PAGESIZE of an output data set?

20: What is the default value of the BUFSIZE= option?

21: Is it necessary to specify the BUFSIZE= option every time a data set is processed?

22: What does the BUFNO= option signify?

23: How do you set the BUFNO= option to the maximum possible number?

24: Is it necessary to specify the BUFNO= option every time a data set is processed?

25: What are the general guidelines for specifying the buffer size and buffer number in the case of small data sets?

26: How does the BUFSIZE= and BUFNO= impact the following program?

27: Explain the SASFILE statement.

28: What happens if the size of file in the memory increases during the execution of SASFILE statement?

29: Mention the guidelines to be followed while using SASFILE statement.

30: When is the buffer allocated by the SASFILE statement freed?

31: Which operations are not allowed in a file opened with SASFILE statement?

32: How do you calculate the total number of bytes occupied by a data file if you know the page size?

Data Storage Space

33: What compresses the data storage space required to store a data set?

34: How does the WHERE statement help in reducing data storage space?

35: How do you clean up the storage space?

36: Explain COMPRESS= System option.

37: I have a compressed data set. I want to add an observation to it. Will it allow me to add the new observation? If yes, where will it be added?

38: Explain POINTOBS= data set option.

39: Explain LENGTH, ATTRIB, KEEP and DROP statements.

40: What factors are considered by SAS when calculating the data storage space required for a SAS data file?

41: How does a SAS character variable store data and what is the default length of a character variable?

42: Which step can be taken to reduce the length of a character variable?

43: How does SAS store numeric values and what is the default length of a numeric variable?

44: Explain the significance of PROC COMPARE.

45: What all conditions make a data file an ideal candidate for compression?

46: Explain the compression of a data set.

47: Which option is used for accessing an observation directly in an uncompressed data set?

48: Which option is used for controlling direct access in a compressed data set?

49: Once a SAS data file is compressed, is it possible to change the setting to uncompressed...

Table of contents

• Efficient SAS Programming
• Memory Usage
• Data Storage Space
• Best Practices
• Sorting Strategies
• Samples
• Using Indexes
• Combining Data Vertically
• Combining Data Horizontally
• Lookup Tables
• Formatting Data
• Tracking Changes
• Basics
• Referencing Files
• SAS Programs
• Reports - List and Summary
• SAS Data Sets
• DATA Step
• Formats
• Statistics
• Outputs
• Variables
• Combining Data Sets
• SAS Functions
• DO Loops
• Arrays
• Raw Data
• Date and Time Value
• Line Pointer Controls
• PROC SQL
• Horizontal Joins
• Vertical Joins
• Creating and Managing Tables
• Creating and Managing Indexes
• Creating and Managing Views
• Processing using PROC SQL
• Macro Variables
• Macro Programs
• HR Interview Questions
• INDEX