Tag: programming languages

Quizzes (351) Questions (7021)

Questions Related to programming languages

Multiple choice technology programming languages

Which PROC SQL query will remove duplicate values of MemberType from the query output, so that only the unique values are listed?

  1. proc sql nodup; select membertype from sasuser.frequentflyers;

  2. proc sql; select distinct(membertype) as MemberType from sasuser.frequentflyers;

  3. proc sql; select unique membertype from sasuser.frequentflyers group by membertype;

  4. proc sql; select distinct membertype from sasuser.frequentflyers;
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation
Multiple choice technology programming languages

Bonus dataset ID Bonus 123 5000 456 7000 744 3500 Salary Dataset ID Salary 123 70000 456 80000 978 55000 Given the PROC SQL query and tables shown below, which output is generated? proc sql; select s.*, bonus from bonus as b right join salary as s on b.id= s.id;

  1. ID Salary Bonus 123 70000 5000 456 80000 7000 978 55000 3500

  2. ID Salary Bonus 123 70000 5000 456 80000 7000 744 . 3500

  3. ID Salary Bonus 123 70000 5000 456 80000 7000 744 55000 3500

  4. ID Salary Bonus 123 70000 5000 456 80000 7000 978 55000 .
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation
Multiple choice technology programming languages

Which statement about the use of table aliases is false?

  1. Table aliases must be used when referencing identical table names from different libraries.

  2. Table aliases can be referenced by using the keyword AS.

  3. Table aliases (or full table names) must be used when referencing a column name that is the same in two or more tables.

  4. Table aliases must be used when using summary functions.
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation
Multiple choice technology programming languages

You are creating a PROC SQL query that will list all employees who have spent (or overspent) their allotted 120 hours of vacation for the current year. The hours that each employee used are stored in the existing column Spent. Your query defines a new column, Balance, to calculate each employee’s balance of vacation hours. Which query will produce the report that you want?

  1. proc sql; select name, spent, 120-spent as calculated Balance from Company.Absences where balance <= 0;

  2. proc sql; select name, spent, 120-spent as Balance from Company.Absences where calculated balance <= 0;

  3. proc sql; select name, spent, 120-spent as Balance from Company.Absences where balance <= 0;

  4. proc sql; select name, spent, 120-spent as calculated Balance from Company.Absences where calculated balance <= 0;
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation