This Advanced SAS certification quiz assesses key skills in SQL query formulation within SAS, focusing on data manipulation, query optimization, and understanding of database interactions crucial for advanced data analysis roles.
All donors whose rows do not contain any missing values.
All donors who made a contribution in the current year.
All donors who did not make a contribution in the current year.
Ll donors whose current year's donation in Charity.Current has not yet been added to Total in Charity.Donors.
Rate this question:
Proc sql; select name, spent, 120-spent as calculated Balance rom Company.Absences where balance <= 0;
Proc sql; select name, spent, 120-spent as Balance from Company.Absences where calculated balance <= 0;
Proc sql; select name, spent, 120-spent as Balance from Company.Absences where balance <= 0;
Proc sql; select name, spent, 120-spent as calculated Balance from Company.Absences where calculated balance <= 0;
Rate this question:
Returns a single value to the outer query.
Contains at least one summary function.
Executes independently of the outer query.
Requires only a single value to be passed to it by the outer query.
Rate this question:
Proc sql; select name, checkedout from library.circulation where * in (select * from library.volunteers);
Proc sql; select name, checkedout from library.circulation where name in (select name from library.volunteers);
Proc sql; select name from library.volunteers where name, checkedout in (select name, checkedout from library.circulation);
Proc sql; select name, checkedout from library.circulation where name in (select name from library.volunteers;);
Rate this question:
150
7
4
1
Rate this question:
The query syntax is not valid.
The outer query must pass values to the subquery before the subquery can return values to the outer query.
The outer query must pass values to the subquery before the subquery can return values to the outer query.
After the query is submitted, the SAS log will indicate whether the query has valid syntax.
Rate this question:
No. This query will not run because a HAVING clause cannot contain a summary function.
No. This query will not run because the HAVING clause must include the CALCULATED keyword before the summary function.
No. Because there is no GROUP BY clause, the HAVING clause treats the entire table as one group.
Yes
Rate this question:
Proc sql nodup; select membertype from sasuser.frequentflyers;
Proc sql; select distinct(membertype) as MemberType from sasuser.frequentflyers;
Proc sql; select unique membertype from sasuser.frequentflyers group by member type;
Proc sql; select distinct membertype from sasuser.frequentflyers;
Rate this question:
When PROC SQL remerges data, it combines data from two tables.
By using data remerging, PROC SQL can avoid making two passes through the data.
When PROC SQL remerges data, it displays a related message in the SAS log.
PROC SQL does not attempt to remerge data unless a subquery is used.
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.
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
|
Wait!
Here's an interesting quiz for you.