SAS Quiz(100% New And Real Time Questions)

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Pythonlearn20160
P
Pythonlearn20160
Community Contributor
Quizzes Created: 1 | Total Attempts: 471
| Attempts: 471
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/20 Questions

    The following SAS program is submitted.%let city=delhi;%let no=9;%let mycity=no;%let country=mycity;%put &&&&&&&country;What is written to the SAS log? 

    • Delhi
    • Apparent symbol is not resolved
    • Mycity
    • 9
Please wait...
SAS Quizzes & Trivia
About This Quiz

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 their proficiency in SAS programming, ensuring readiness for practical applications in data analysis.

Quiz Preview

  • 2. 

    Which of the following is a debugging technique in PROC SQL 

    • MLOGIC

    • FEEDBACK

    • MPRINT

    • VALIDATE

    Correct Answer(s)
    A. FEEDBACK
    A. VALIDATE
    Explanation
    FEEDBACK is a debugging technique in PROC SQL that provides information about the execution of the SQL statements. It displays messages in the SAS log, allowing the programmer to identify and correct any errors or issues in the SQL code. VALIDATE is another debugging technique in PROC SQL that checks the syntax and semantics of the SQL statements without actually executing them. It helps in identifying any errors or inconsistencies in the code before running the SQL queries.

    Rate this question:

  • 3. 
    Below two datasets ONE and TWO are submitted.DATA ONE;INPUT EMPID EMP_NAME$;DATALINES;10 JACK20 JONE30 GILT39 HENRY55 ROCK;RUN;DATA TWO;INPUT EMPD EMP_NAME$;DATALINES;10 HENRY34 NOSY55 JOHN24 REMO;RUN;which of the following will the create output dataset THREE? - ProProfs

    Below two datasets ONE and TWO are submitted.DATA ONE;INPUT EMPID EMP_NAME$;DATALINES;10 JACK20 JONE30 GILT39 HENRY55 ROCK;RUN;DATA TWO;INPUT EMPD EMP_NAME$;DATALINES;10 HENRY34 NOSY55 JOHN24 REMO;RUN;which of the following will the create output dataset THREE?

    • PROC SQL; CREATE TABLE THREE LIKE SELECT * FROM ONE OUTER UNION SELECT * FROM TWO; QUIT;

    • PROC SQL; CREATE TABLE THREE AS SELECT * FROM ONE OUTER UNION SELECT * FROM TWO; QUIT;

    • PROC SQL; VALIDATE CREATE TABLE THREE AS SELECT * FROM ONE OUTER UNION SELECT * FROM TWO; QUIT;

    • PROC SQL; CREATE TABLE THREE AS SELECT * FROM ONE OUTER UNION, SELECT * FROM TWO; QUIT;

    Correct Answer
    A. PROC SQL; CREATE TABLE THREE AS SELECT * FROM ONE OUTER UNION SELECT * FROM TWO; QUIT;
    Explanation
    The correct answer is "PROC SQL; CREATE TABLE THREE AS SELECT * FROM ONE OUTER UNION SELECT * FROM TWO; QUIT;". This code will create an output dataset named THREE using the SQL procedure. It will combine the datasets ONE and TWO using the OUTER UNION operator, which will include all rows from both datasets, including any duplicates. The SELECT * statement is used to select all columns from both datasets, and the resulting dataset will contain all the columns from both datasets.

    Rate this question:

  • 4. 

      PRIMARY KEY  is the type of integrity constraint you  would place on the variable StoreID to ensure that there are no missing values and that there are no duplicate values ?

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The primary key is a type of integrity constraint that ensures the uniqueness and non-nullability of a column. By applying the primary key constraint on the variable StoreID, it guarantees that there are no missing values (non-nullability) and no duplicate values (uniqueness). This constraint is commonly used to uniquely identify each row in a table and enforce data integrity. Therefore, the given answer of "True" is correct.

    Rate this question:

  • 5. 
    Which of the following will create the output as shown in figure? - ProProfs

    Which of the following will create the output as shown in figure?

    • MLOGIC

    • SYSTEMOPTION

    • %PUT AUTOMATIC ;

    • %PUT _ALL_;

    Correct Answer
    A. %PUT _ALL_;
    Explanation
    The correct answer is "%PUT _ALL_;" because the "%PUT _ALL_;" statement is used to display all the automatic macro variables and their values in the SAS log. In this case, it will display the value of the macro variable AUTOMATIC.

    Rate this question:

  • 6. 

    What does an FLOW OVER option do in an ODS Statement ?

    • Moves the output pointer to a new line if a PUT statement attempts to write an item beyond the last ODS column in the buffer

    • Stops the output pointer to a new line if a PUT statement attempts to write an item beyond the last ODS column in the buffer

    • Discards the output pointer to a new line if a PUT statement attempts to write an item beyond the last ODS column in the buffer

    • None of the above

    Correct Answer
    A. Moves the output pointer to a new line if a PUT statement attempts to write an item beyond the last ODS column in the buffer
    Explanation
    The FLOW OVER option in an ODS Statement moves the output pointer to a new line if a PUT statement attempts to write an item beyond the last ODS column in the buffer. This means that if the output exceeds the available space in the current line, it will automatically wrap to the next line, ensuring that the output is properly displayed without any truncation or loss of data.

    Rate this question:

  • 7. 

    Suppose we have a dataset named CLASS with four variables NAME, GENDER, SEX and CLASS. Which of the following will create an index on GENDER and CLASS.

    • Proc sql; Create unique index daily on work.CLASS (GENDER, CLASS) ;

    • Proc sql; New unique index daily on work.CLASS (GENDER, CLASS);

    • Proc sql; Create unique index GENDER, CLASS on work. CLASS (GENDER, CLASS);

    • Proc sql; Create PRIMARY index on work. CLASS (GENDER, CLASS);

    Correct Answer
    A. Proc sql; Create unique index daily on work.CLASS (GENDER, CLASS) ;
    Explanation
    The correct answer is "Proc sql; Create unique index daily on work.CLASS (GENDER, CLASS) ;". This statement creates a unique index named "daily" on the dataset "CLASS" in the "work" library, with the index key variables as "GENDER" and "CLASS". This means that the index will be created based on the values of these two variables, allowing for faster data retrieval and improved performance when querying the dataset based on these variables.

    Rate this question:

  • 8. 

    Which of the following will direct SAS to ignore all indexes in the following procedure

    • Proc sql; Select * from sasuser.cars (idxwhere=no) where speed > 150 ; Quit;

    • Proc sql; Select * from sasuser.cars (idxwhere=ignore) where speed > 150; Quit;

    • Proc sql; Select * from new. Cars (idxwhere=point) where speed > 150; Quit;

    • Proc sql; Select * from new. Cars (idxwhere=yes) where speed > 150; Quit;

    Correct Answer
    A. Proc sql; Select * from sasuser.cars (idxwhere=no) where speed > 150 ; Quit;
    Explanation
    The correct answer is "proc sql; Select * from sasuser.cars (idxwhere=no) where speed > 150 ; Quit;". This is because the "idxwhere=no" option in the PROC SQL statement tells SAS to ignore all indexes when executing the query.

    Rate this question:

  • 9. 

    Which of the following macro variable resolves to Joan’s Report

    • %let text=%bquote(Joan's Report);

    • %let text=Joan%str(')s Report;

    • %let text=bquote(Joan's Report);

    • %let text=Joan%str(',)s Report;

    Correct Answer
    A. %let text=%bquote(Joan's Report);
    Explanation
    The correct answer is "%let text=%bquote(Joan's Report);" because the %bquote function is used to mask special characters in a macro variable value. In this case, the single quote in "Joan's Report" is masked using %bquote, so the macro variable resolves to "Joan's Report" without any syntax errors.

    Rate this question:

  • 10. 

    %let summit= brics2016;Which one of the following statements stores the value brics in the macro variable summitname?

    • %let summitname= %substr(&summit,%length(&summit)-4);

    • %let summitname= %nrsubstr(summit,1,%length(&summit)-4);

    • %let summitname= %substr(&summit,1,%length(&summit)-4);

    • %let summitname= %substr(&summit,1,length (&summit)-4);

    Correct Answer
    A. %let summitname= %substr(&summit,1,%length(&summit)-4);
    Explanation
    The correct answer is %let summitname= %substr(&summit,1,%length(&summit)-4). This statement uses the %substr function to extract a substring from the macro variable summit. It starts at the first character and goes up to the length of the variable minus 4, effectively removing the last 4 characters from the value of summit. The resulting substring is then stored in the macro variable summitname.

    Rate this question:

  • 11. 

       %let a= 10;   %let b= 9;   %let c= %sysevalf(&a/ &b);   %put &c; What is written to SAS Log ?

    • Macro variable C resolves to 1.11111

    • Macro variable C resolves to 1.12

    • Macro variable C resolves to 1

    • Macro variable C resolves to 10/9

    Correct Answer
    A. Macro variable C resolves to 1.11111
    Explanation
    The macro variable C resolves to 1.11111 because the %sysevalf function is used to perform a floating-point division of the values of macro variables a and b. The result of the division is 1.11111, which is then assigned to the macro variable C. This value is then printed to the SAS Log using the %put statement.

    Rate this question:

  • 12. 

    The following SAS program is submitted.data match; array balls{4,2}_temporary_ (10,20,30,40,50,60,70); runs= balls{4,2}; run;Which one of the following is the value of the variable runs in the data set match

    • 20

    • 40

    • NULL/BLANK

    • Unable to determine/error

    Correct Answer
    A. NULL/BLANK
    Explanation
    The variable "runs" is assigned the value of the element in the array "balls" with indexes 4 and 2, which is NULL/BLANK.

    Rate this question:

  • 13. 

    Which statement is false regarding the keyword CORRESPONDING? 

    • It cannot be used with the keyword ALL.

    • It overlays columns by name, not by position.

    • When used in EXCEPT, INTERSECT, and UNION set operations, it removes any columns not found in both tables.

    • When used in OUTER UNION set operations, it causes same-named columns to be overlaid.

    Correct Answer
    A. It cannot be used with the keyword ALL.
    Explanation
    The keyword CORRESPONDING can be used with the keyword ALL.

    Rate this question:

  • 14. 

    If you store a macro definition in a SAS catalog SOURCE entry 

    • You can use FILENAME and %INCLUDE statements for compiling the macro

    • You can use the PROC CATALOG statement to compile the macro

    • The SOURCE entry is deleted at the end of the session

    • You do not need to compile the macro before you invoke it in a program.

    Correct Answer
    A. You can use FILENAME and %INCLUDE statements for compiling the macro
    Explanation
    Storing a macro definition in a SAS catalog SOURCE entry allows you to use FILENAME and %INCLUDE statements for compiling the macro. This means that you can include the macro definition in your program using the %INCLUDE statement, and the macro will be compiled and available for use. The FILENAME statement is used to specify the location of the macro definition in the SAS catalog. This allows for easy access and compilation of the macro without the need to manually compile it before invoking it in a program.

    Rate this question:

  • 15. 

    Which SQL procedure program deletes rows from the data set CLASS ?

    • Proc sql; delete from newdata.class Where age

    • Proc sql; delete from newdata.class age

    • Proc sql; delete from newdata.class Where age

    • Proc sql; delete from newdata.class Where age

    Correct Answer
    A. Proc sql; delete from newdata.class Where age
    Explanation
    The correct answer is "proc sql; delete from newdata.class Where age". This SQL procedure program uses the "delete" statement to remove rows from the data set "CLASS" where the condition "age" is met.

    Rate this question:

  • 16. 
    Given the following program, What is the point value of “henry” in the dataset two ?data two;array score{2,4} _temporary_(40,50,60,70,40,50,60,70);set work.one;Points=score{hour,rating};run; - ProProfs

    Given the following program, What is the point value of “henry” in the dataset two ?data two;array score{2,4} _temporary_(40,50,60,70,40,50,60,70);set work.one;Points=score{hour,rating};run;

    • 40

    • 50

    • 60

    • 70

    Correct Answer
    A. 60
    Explanation
    The program is creating an array called "score" with dimensions 2x4 and initializing it with values 40, 50, 60, and 70. Then, it is using the "set" statement to read data from a dataset called "work.one". Finally, it is assigning the value of "score{hour,rating}" to the variable "Points". Since the array "score" has 2 rows and 4 columns, the expression "score{hour,rating}" is accessing the value at the intersection of the "hour" row and the "rating" column, which is 60.

    Rate this question:

  • 17. 
    Given two sas datasets class1 and class2;data class1;input name$ rank exams;datalines;Alice 4 1Carol 2 1Henry 3 1James 1 2Janet 2 2louis 3 2leani 4 2;run;data class2;input name$ rank exams;datalines;Barbara 1 1Jeffrey 5 1William 5 2;run;which of the following will produce the given output? - ProProfs

    Given two sas datasets class1 and class2;data class1;input name$ rank exams;datalines;Alice 4 1Carol 2 1Henry 3 1James 1 2Janet 2 2louis 3 2leani 4 2;run;data class2;input name$ rank exams;datalines;Barbara 1 1Jeffrey 5 1William 5 2;run;which of the following will produce the given output?

    • Proc sql; select * from class1 union all select * from class2 where class1.rank=class2.rank; quit;

    • Proc sql; select * from class1 union all select * from class2 quit;

    • Proc sql; select * from class1,class2; quit;

    • Proc sql; select * from class1 union select * from class2 quit;

    Correct Answer
    A. Proc sql; select * from class1,class2; quit;
  • 18. 
    Given two sas datasets class1 and class2;data class1;input name$ rank exams;datalines;Alice 4 1Carol 2 1Henry 3 1James 1 2Janet 2 2louis 3 2leani 4 2;run;data class2;input name$ rank exams;datalines;Barbara 1 1Jeffrey 5 1William 5 2;run;which of the following will produce the given output? - ProProfs

    Given two sas datasets class1 and class2;data class1;input name$ rank exams;datalines;Alice 4 1Carol 2 1Henry 3 1James 1 2Janet 2 2louis 3 2leani 4 2;run;data class2;input name$ rank exams;datalines;Barbara 1 1Jeffrey 5 1William 5 2;run;which of the following will produce the given output?

    • Proc sql; select * from class1 union select * from class2 order by exams; quit;

    • Proc sql; select * from class1 outer union select * from class2 on class1.exams=class2.exams quit;

    • Proc sql; select * from class1 left join select * from class2 on class1.exams=class2.exams; quit;

    • Proc sql; select * from class1 union all select * from class2 quit;

    Correct Answer
    A. Proc sql; select * from class1 union select * from class2 order by exams; quit;
    Explanation
    The correct answer is "proc sql; select * from class1 union select * from class2 order by exams; quit;". This query combines the data from both class1 and class2 datasets using the UNION operator and sorts the result by the exams column. The UNION operator eliminates duplicate rows from the result set.

    Rate this question:

  • 19. 
    Given the following datasets class1,class2 and class3data class1;input name$ id bus_no fee_status$;datalines;Alice 9 1 YCarol 8 1 Y;run;data class2;input name$ id bus_no fee_status$;datalines;Barbara 1 1 YJeffrey 5 2 N;run;data class3;input name$ id bus_no fee_status$;datalines;Judy 4 2 NMary 3 2 Y;run; - ProProfs

    Given the following datasets class1,class2 and class3data class1;input name$ id bus_no fee_status$;datalines;Alice 9 1 YCarol 8 1 Y;run;data class2;input name$ id bus_no fee_status$;datalines;Barbara 1 1 YJeffrey 5 2 N;run;data class3;input name$ id bus_no fee_status$;datalines;Judy 4 2 NMary 3 2 Y;run;

    • Data work.class; Set class1 class2 class3; Where id >5; Run;

    • Data work.class; Set class1 class2 class3; Where id ge 5; Run;

    • Data work.class; merge class1 class2 class3; Where id ge 5; Run;

    • Data work.class; merge class1 class2 class3; Where id > 5; Run;

    Correct Answer
    A. Data work.class; Set class1 class2 class3; Where id >5; Run;
    Explanation
    The correct answer is "Data work.class; Set class1 class2 class3; Where id >5; Run;". This is the correct answer because it uses the SET statement to combine the datasets class1, class2, and class3 into a single dataset called work.class. The WHERE statement is then used to filter the observations, only selecting those where the id variable is greater than 5. Finally, the RUN statement is used to execute the data step and create the new dataset.

    Rate this question:

  • 20. 

    The SAS data set ONE contains the variables P,Q,R and S.The following SAS program is submitted:Proc transpose data =oneOut=transName=new;By P;var Q;run;

    • New, R,S and _COL1_

    • New, P and COL1 only

    • _COL1_,_COL2_ AND _COL3_ ONLY

    • P,Q AND R ONLY

    Correct Answer
    A. New, P and COL1 only
    Explanation
    The SAS program is using the PROC TRANSPOSE statement to restructure the data set ONE. The BY statement is used to group the observations by the variable P. The VAR statement specifies that only variable Q should be transposed. The resulting transposed data set, named new, will contain the variables P and COL1 only.

    Rate this question:

Quiz Review Timeline (Updated): Mar 20, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 20, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Aug 07, 2016
    Quiz Created by
    Pythonlearn20160

Related Topics

Recent Quizzes

SAS Admin Trivia Quiz SAS Admin Trivia Quiz
SAS Chapter 22: Using Best Practices SAS Chapter 22: Using Best Practices
SAS Chapter 18: Modifying SAS Data Sets and Tracking Changes SAS Chapter 18: Modifying SAS Data Sets and Tracking Changes
SAS Chapter 17: Formatting Data SAS Chapter 17: Formatting Data
SAS Chapter 15: Combining Data Horizontally SAS Chapter 15: Combining Data Horizontally
SAS Chapter 14: Combining Data Vertically SAS Chapter 14: Combining Data Vertically
SAS Chapter 13: Creating Samples and Indexes SAS Chapter 13: Creating Samples and Indexes
SAS Chapter 12: Storing Macro Programs SAS Chapter 12: Storing Macro Programs
SAS Chapter 10: Processing Macro Variables at Execution Time SAS Chapter 10: Processing Macro Variables at Execution Time

Featured Quizzes

Best Friend Quiz: Are You Really Best Friends? Best Friend Quiz: Are You Really Best Friends?
What Ethnicity Do I Look Like? What Ethnicity Do I Look Like?
Introduction to Computer: MCQ Questions With Answers Introduction to Computer: MCQ Questions With Answers
Articles Quiz With Answers Articles Quiz With Answers
Which Sonic Character Are You? Which Sonic Character Are You?
What Is My Ethnicity? Let's Take Ethnicity Quiz What Is My Ethnicity? Let's Take Ethnicity Quiz
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.