Base SAS Certification Questions and Answers to Practice for Exam

SAS Base Exam Questions and Answers to Pass the Exam for gaining Certification

The SAS certification endorses your skills and will make your employment ready. You will get recognition for your knowledge with this SAS certification. These base SAS certification questions are a quick practice test of what you have learned before you appear your SAS base certification exam. You can glance online practice at them quickly and appear at the certification exam confidently. These sample SAS base exam questions help you to get free practice and to check your test score. We have prepared over 30+ multiple choice questions and answers for sas base test preparation to the test takers for gaining confidence to pass the exam.

Exam Details: Basic programmer

Exam Name: SAS Global certification program

Exam Duration: 100 minutes/1 hours 67 minutes

No. of Questions: 50-55

Passing Score: 70%

Validated Against: SAS Pearson VUE

Test Format: Multiple Choice Questions and Short Answers

Exam ID A00-21

Exam Cost: $180

-----------------------------------------------------------------------------------------------------------------

Q 1-

libname rawdata1 'SAS data library location'; filename rawdata2 'raw data file location'; data work.testdata; infile input sales1 sales2; run;

To complete the above program, which one of the given is required?

•          rawdata1
•          rawdata2
•          ‘rawdata1’
•          ‘rawdata2 ’

As the path of the file is already initialized along with the name of the file so there is no need to add the quotation of the file again.

--------------------------------------------------------------------------------------------------------------

Q 2- Which of the given options is true when a data error is detected by the SAS in a DATA step?

•          At the point of error, the DATA step stops the execution and the final DATA set consists of the report up to the point
•          A dialogue appears within the log of SAS regarding the incorrect information or data which is stored to a distinct SAS file for some examinations
•          The error is explained within a dialogue box and the execution gets continued by the DATA step
•          Execution stopped by DATA step at the error point and no data set is created in SAS

The problem can be within the syntax or the data can be invalid so the error is explained according to the compilation process and execution continues

------------------------------------------------------------------------------------------------------------

Q 3- How to limit the variables that are included in the DATA step output dataset?

•          DROP
•          RETAIN
•          VAR
•          None of the above

DROP option is used to drop a variable and this option is used to drop multiple variables specifically according to the requirements while writing it to the data set output.

-------------------------------------------------------------------------------------------------------------

Q 4- To create a dataset of SAS and to read delimited raw data file, which one of the given statements is used?

•          DATA, SET and INPUT
•          DATA, INFILE and INPUT
•          DATA and SET
•          DATA, SET and INFILE

SET cannot read the raw data file because it is created to read the information and data from single or multiple datasets.

--------------------------------------------------------------------------------------------------------

Q 5- Which one of the give statements is true in relation to the RETAIN statement in a program of SAS DATA step?

•          It does not put any impact on the variables read with the UPDATE, SET and MERGE statements        
•          Helps in assigning an initial value to _N_
•          It is only suitable in combination with a SUM function
•          It ignores some missing values and adds the value of an expression to an accumulator variable

The RETAIN statement works on the compile time where some variables are created if they are not existing. Moreover, it does not put any impact on the SET, UPDATE and MERGE statements.

------------------------------------------------------------------------------------------------------------------

Q 6- Which one of the given is true when an error is encountered by SAS within a DATA step?

•          DATA step stops the execution
•          The main work of the DATA step is to stop the execution of the program at the error point and there is no SAS data set is generated.   
•          In the SAS log, a dialogue shows that the incorrect data record was stored to a distinct SAS file for other evaluations
•          A dialogue box comes to the SAS log that defines the error but the execution of the DATA step continues

Errors can be related to the syntax and while merging multiple datasets with each other.

-------------------------------------------------------------------------------------------------------------------

Q 7- Choose and explain one of the given statements that explain the failed execution of a program?

•          Execution failed due to some kind of syntax error in the program code
•          The data sets are not orderly merged as they were sorted before
•          The merged data sets are temporary SAS data sets
•          After each of the SORT procedures, the RUN statements were absent

The arrangement of two proc sorts is done in descending order. Nevertheless, the merging is done in ascending order which is why the merging of two data sets cannot be done.

------------------------------------------------------------------------------------------------------------------

Q 8- Select one of the given options as the type of variables for which it is sensible to make some dummy variables?

•          Gender
•          Race
•          Gender & Race both
•          Date of Birth

It makes sense to make dummy variables because these variables do include almost similar values.

----------------------------------------------------------------------------------------------------------------

Q 9- Which one of the following is the keyword that is used to save the values in a variable?

•          Run
•          Input
•          Data lines
•          Data

The keyword Run is used to execute the program and the Input and Data keywords are used to insert new values to the dataset within the program. Data lines keyword saves the value in the particular variable.

----------------------------------------------------------------------------------------------------------------

Q 10- Choose one of the following options that are not able to be the element of “PROC FREQ”?

•          Set
•          Tables
•          Weight
•          Output

Set is not used for the counting, showing and counting the categorical kind of data that it why it is not used for “PROC FREQ”.

---------------------------------------------------------------------------------------------------------------

 Q 11- In the table AV, how many variables will be there after the execution of the given SAS program?

   data AV;  merge Employee Salary;  by name; total + salary; run;

•          3
•          4
•          5
•          6

There will be four variables

------------------------------------------------------------------------------------------------------------------

Q 12- Please select one of the true statements of PROC from the options given below?

•          PROC means
•          PROC freq
•          PROC contents
•          All

All PROC statements are right where PROC means is used for quantity, PROC freq is used for analyzing data and PROC contents put impacts on the outcome of the program.

--------------------------------------------------------------------------------------------------------------

Q 13- Select one of the following options that explain the term “what has happened”?

•          Predictive
•          Prescriptive
•          Diagnostic
•          Descriptive    

Descriptive analysis is basically used for defining the common features of data and make use of inferential statistics for making probable judgments.

-----------------------------------------------------------------------------------------------------------------

Q14- If observation value weight is ZERO, then what happens?

•          Observation is ignored from the analysis process
•          Deletion of observation from analysis
•          Observation kept
•          None of the above

If the value of the weight of observation is Zero then the observation cannot be stored within the dataset so it is deleted.

-----------------------------------------------------------------------------------------------------------------

Q 15- In order to read many records with sequences, which pointer control is used from the below options?

•          / (forward stash)
•          +N
•          @n
•          All the above

The answer is forward stash (/) which a line pointer is mostly used for the input statement so the SAS can identify the new record before going for the next value to read.

--------------------------------------------------------------------------------------------------------------------

Q 16- Identify the PROC from the below options that is used for creating “Histogram” and “Scatter”?

•          PROC PLOT
•          PROC UNIVARIATE
•          PROC SGPLOT
•          None

PROC SGPLOT is used for creating multiple charts such as histogram, bubble and scatter etc.

-----------------------------------------------------------------------------------------------------------------

Q 17- There is a program given below with PROC SORT step, it creates a data set for output as given below:

proc sort data = AV.employee out = employee;

    by Designation;

run;

Identify from the below options where the output of the library will be saved?

•          AV
•          Work
•          SASUSER
•          SASHELP

As the library name is not given properly so the output will be already saved within the temporary library called “WORK”.        

---------------------------------------------------------------------------------------------------------------

Q 18- Identify from the below date formats that will show the SAS data value for February 17, 2017 in the form of 17/20/2017?

•          WEEKDATE10
•          DATE10
•          DDMMYY10
•          DDMMYYYY10

The length of the data value is 10 bytes long and it is in the format of date month and year. For this format, the DDMMYY10 format is used that supports this type of data value. DDMMYYYY10 will be incorrect for this.

---------------------------------------------------------------------------------------------------------------

Q 19- Explain from the below options that can be used to show the content in the SAS session of an external file?

•          The LIST procedure
•          The VIEWTABLE window
•          The FSLIST procedure
•          The PRINT procedure

Only FSLIST procedure show content in the external file and the others are used to show the content within the SAS datasets.

--------------------------------------------------------------------------------------------------------------

Q 20- Select one procedure from below options that can be used to associate a format along with variables permanently?

•          An INPUT statement with having a formatted input style
•          INPUT with format modifier
•          FORMAT statement within a data step
•          FORMAT procedure

For permanently associating some format along with a variable, it is important to make use of the FORMAT statement within a DATA step. The FORMAT procedure is used to generate a user-defined format. Moreover, the INPUT function is used for converting the character data values to the numeric type data within a format.

------------------------------------------------------------------------------------------------------------------

Q 21- A report of SAS presently follows over two pages as it is big for the dimension of the specified display. Answer one of the following options give below that what action will be used for changing the dimension of the display in order to fit the report on the page?

•          Increasing the LINENO option value
•          Increase the PAGESIZE option value
•          Decrease LINESIZE option value
•          Decrease the PAGENO option value

PAGESIZE option is made for controlling the line numbers for composing the SAS output page. As the number of lines increased, the report can be fitted within the page accordingly.

--------------------------------------------------------------------------------------------------------------

Q 22- Select from the below options of SAS REPORT procedure that puts control on the way the headings can be shown over many lines?

•          BREAK=
•          LABEL=
•          SPLIT=
•          SPACE=

The SPLIT option is used to specifying the way the column headings will split and the other options are not valid.

------------------------------------------------------------------------------------------------------------

Q 23- Which is one of the given statements that occurs when the SAS detects some kind of error in syntax within the DATA step?

•          A dialogue comes in SAS log saying syntax error is stored in SAS dataset
•          Execution stopped by DATA step
•          Continuous execution be DATA step
•          SAS log explaining the error

SAS examine the DATA step in order to detect the errors in the syntax while compilation process. If syntax error detected, the error code is displayed on the error log. The further process will be stopped for processing.

-----------------------------------------------------------------------------------------------------------------

Q 24- A HTML file consists of a SAS report. Select one of the given ODS statement options that can be used for specifying the HTML file name?

•          HTMLFILE=
•          FILE=
•          HTML=
•          OUT=

The option FILE= is used to identify the file consisting the output of the HTML file.

-----------------------------------------------------------------------------------------------------------------

Q 25- There is a program given below

Proc contents data=sasuser ._all_ nods;

Which of the below output will be produced for the given program?

•          A data set list which is named in the sasuser library
•          Descriptor section of each data set within the sasuser library
•          Descriptor portion named Sasuser. All_
•          None of the above

The CONTENTS procedure is basically used for generating SAS output in order to describe the library contents. _All_ helps to do the listing of the files within the library.

------------------------------------------------------------------------------------------------------------

Q 26- Define the given statements which are valid when SAS detect some type of error in the program?

•          The phase of execution is stopped, a system error occurs
•          Assigning of the missing value to the most suitable variable and the continuous execution is done
•          A SAS data set is generated with zero observations and the phase of execution is stopped
•          A missing value is given to a suitable variable and at some point, the execution is stopped 

SAS does not stop the execution because of the data errors, it only happens in the case of syntax error. SAS has the ability to handle the data errors by giving missing value and display a dialogue box to the SAS log.

---------------------------------------------------------------------------------------------------------------

Q 27- Which of the below options, SAS is mostly used for?

•          Used for data mining
•          Used for text analytics
•          For simulation purposes
•          All of the above

SAS can be used for multiple purposes such as mining of information and data in the database management systems, for text analytics, information simulation etc.

---------------------------------------------------------------------------------------------------------------

Q 28- Identify the value of the weight variable at the time of adding weight?

•          Positive
•          Negative
•          Zero
•          Positive and negative both

Adding values will always give positive results as the weight gets summed up with the existing variables.

---------------------------------------------------------------------------------------------------------------

Q 29- In SAS, one can test joint and single both types of a hypothesis after proper completion of?

•          Testing
•          Plots
•          Estimations
•          Data limitations

Estimations are done for preparation of the outcome and get ready for the expected results according to the estimated results.

-------------------------------------------------------------------------------------------------------------------

Q 30- The statement PROC MEANS is used for which of the following options?

•          Incorrectly coded values
•          Program execution
•          Weight Increment
•          Wrong syntax program

The PROC MEANS does work fine even when the values are coded incorrectly. This statement can handle the incorrectly coded values and continuously executes the statement accordingly.

----------------------------------------------------------------------------------------------------------------

Q 31- Which of the following options reduces the management time and the deploy models in the production?

•          Model Manager
•          Compiler
•          Interpreter
•          Simulation model 

Model managers manage the time taken by the SAS program execution and it also does deployments of the models within the production process.

--------------------------------------------------------------------------------------------------------------------

Q 32- Which of the following element maximize the accuracy and the performance of the analytics models in SAS?

•          Development of model
•          Data performance
•          Acceleration of performance
•          Accelerating scoring

The scoring acceleration helps in the movement of data and does replication in the processing of streamline in data analytics.

------------------------------------------------------------------------------------------------------------------

Q 33- Which of the following command is used for reading the data that is loaded in SAS in the editor window?

•          load NAME_OF_FILE
•          Data NAME_OF_FILE
•          Read NAME_OF_FILE
•          execute NAME_OF_FILE

Data NAME_OF_FILE command is used after the data is loaded in SAS as it works within the editor window and read the data accordingly.

------------------------------------------------------------------------------------------------------------------

Q 34- Select from the options that explain the use of the array in SAS?

•          Grouping of variables of SAS temporarily
•          Referring to variables of SAS temporarily
•          Arrays do not exist in SAS
•          Both Grouping and Referring to SAS variables temporarily

The variables of the SAS can only be grouped with the help of arrays as it contains the set of values accordingly. Referring to the SAS variables are done on the temporary note. Permanent grouping and referring is not possible with the array.

------------------------------------------------------------------------------------------------------------------

Q 35- Selection one of the following function of the resource and project scheduling?

•          Operation research
•          Development of operations
•          Acceleration of scoring
•          Model development

Operation research is the process to make some research on the operations within SAS and use qualitative and quantitative research procedures.

--------------------------------------------------------------------------------------------------------------------

Q 36- Select from the following options that can quickly detect the opportunities and relationship with the use of advanced statistical techniques?

•          Acceleration of scoring
•          Deployment and development of model
•          Data forecasting
•          Development of model

Development and deployment of the model are the components that can identify the opportunities for SAS. They make use of different advanced techniques that provide results based on statistics.

---------------------------------------------------------------------------------------------------------------

Q 37- Choose from the below options and identify the benefits of visual data discovery?

•          Overcoming the limitation of data
•          Assist in achieving corporate compliance
•          Permits for the good level for user interaction
•          All

Visual data discovery gives an amazing user interface that helps in better analysis of the data and provides an amazing and effective presentation of the outcome.

------------------------------------------------------------------------------------------------------------------

Q 38- Which of the following option is the correct statement of PROC?

•          PROC content
•          PROC freq
•          PROC means
•          All

PROC content is the procedure that creates the information for the summary regarding the datasets and its content. PROC means is used for the values that are coded incorrectly. PROC freq generates cross tabulation tables.