SAS Chapter 20: Controlling Memory Usage
-
The total number of bytes occupied by a data set equals…?
-
The page size multiplied by the number of pages.
-
The page size multiplied by the number of observations.
-
The sum of the page size and the number of pages.
-
The number of pages multiplied by the number of variables.
-
Practice for the SAS advance certification exam.
Quiz Preview
- 2.
Which of the following statements is true regarding a file that is opened with the SASFILE statement?
-
The file is available to subsequent DATA and PROC steps or applications until a SASFILE CLOSE statement is executed or until the program ends.
-
The file is available to subsequent DATA and PROC steps or applications until a SASFILE END statement is executed.
-
The file is available for subsequent utility or output processing until the program ends.
-
If the file increases in size during processing, the number of buffers remains the same.
Correct Answer
A. The file is available to subsequent DATA and PROC steps or applications until a SASFILE CLOSE statement is executed or until the program ends.Explanation
When a SAS data file is opened using the SASFILE statement, the data is held in memory, and is available to subsequent DATA and PROC steps or applications, until either a SASFILE CLOSE statement is executed or the program ends. Though a file that is opened with the SASFILE statement can be used for subsequent input or update processing, it cannot be used for subsequent utility or output processing. If the file in memory increases in size during processing, the number of buffers also increases.Rate this question:
-
- 3.
Which statement opens the file Work.Quarter1, allocates enough buffers to hold the entire file in memory, and reads the data into memory?
-
Sasfile work.quarter1 open;
-
Sasfile work.quarter1 load;
-
Sasfile work.quarter1 bufno=max;
-
Sasfile work.quarter1 bufsize=max;
Correct Answer
A. Sasfile work.quarter1 load;Explanation
The SASFILE LOAD statement opens the file, allocates the buffers, and reads the data into memory.Rate this question:
-
- 4.
Which of the following statements is true regarding the BUFNO= option?
-
The BUFNO= option specifies the size of each buffer that is used for reading or writing a SAS data set.
-
The BUFNO= option can improve execution time by limiting the number of input/output operations that are required.
-
Using the BUFNO= option results in permanent changes to the data set.
-
Using the BUFNO= option to increase the number of buffers results in decreased memory consumption.
Correct Answer
A. The BUFNO= option can improve execution time by limiting the number of input/output operations that are required.Explanation
You can use the BUFNO= system option or data set option to control how many buffers are available for reading or writing a SAS data set. Using BUFNO= can improve execution time by limiting the number of input/output operations that are required for a particular SAS data set. However, the improvement in I/O comes at the cost of increased memory consumption. The buffer number is not a permanent attribute of the data set and is valid only for the current step or SAS session.Rate this question:
-
- 5.
Which of the following statements is not true regarding a page?
-
A page is the unit of data transfer between the engine and the operating environment.
-
A page includes the number of bytes used by the descriptor portion, the data values, and the overhead.
-
The size of a page is analogous to buffer size.
-
The size of a page can be changed at any time.
Correct Answer
A. The size of a page can be changed at any time.Explanation
A page is fixed in size when the data set is created, either to a default value or a specified value. You can use the BUFSIZE= option to control the page size of an output SAS data set. BUFSIZE= specifies not only the page size (in bytes), but also the size of each buffer that is used for reading or writing the SAS data set. The new buffer size is permanent; after it is specified, it is used whenever the data set is processed.Rate this question:
-
Quiz Review Timeline (Updated): Mar 15, 2022 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 15, 2022Quiz Edited by
ProProfs Editorial Team -
Apr 03, 2013Quiz Created by
Moxleyv
SAS QUIZ(100% NEW AND REAL TIME QUESTIONS)
This SAS quiz features real-time questions assessing skills in data handling, debugging, and SQL operations within SAS. It is designed for learners seeking to test and enhance...
Questions:
20 |
Attempts:
486 |
Last updated:
Mar 20, 2023
|
SAS Chapter 22: Using Best Practices
In our ongoing SAS quiz series, we turn our attention to the different practices and which is the best to use in a given situation. What do you know about IF statements, PROC...
Questions:
5 |
Attempts:
106 |
Last updated:
Dec 06, 2023
|
SAS Chapter 12: Storing Macro Programs
This SAS Chapter 12 quiz focuses on storing macro programs. It tests knowledge on %INCLUDE statements, storing macros in SAS catalogs, using the Stored Compiled Macro Facility,...
Questions:
10 |
Attempts:
330 |
Last updated:
Mar 15, 2023
|
SAS Chapter 11: Creating And Using Macro Programs
This quiz assesses knowledge in SAS Macro Programming, focusing on macro creation, parameter handling, and conditional statements. It tests the ability to define, reference, and...
Questions:
10 |
Attempts:
1202 |
Last updated:
Aug 21, 2023
|
SAS Chapter 10: Processing Macro Variables At Execution Time
This quiz, titled 'SAS Chapter 10: Processing Macro Variables at Execution Time,' tests knowledge on macro variable processing in SAS. It covers creating, assigning, and...
Questions:
10 |
Attempts:
355 |
Last updated:
Mar 17, 2023
|
SAS Chapter 9: Introducing Macro Variables
This SAS Chapter 9 quiz focuses on macro variables, testing understanding through questions on their creation, manipulation, and error handling. It's designed to enhance...
Questions:
10 |
Attempts:
724 |
Last updated:
Jan 30, 2024
|
Back to top