Another Typo ADVance certification Book chapter 6 Quiz6

rimal_mahesh — Mon, 05 Oct 2020 07:28:13 GMT

6. What is the FedSQL equivalent of the following PROC SQL query?
proc sql inobs=5;
select *
from certadv.airports
order by ID;
quit;
a. libname certadv v9 'C:\Users\Student\certadv\';
proc fedsql inobs=5;
select *
from certadv.airports
order by ID;
quit;
b. libname certadv v9 'C:\Users\Student\certadv\';
proc fedsql limit 10;
select *
from certadv.airports
order by ID;
quit;
c. libname certadv v9 'C:\Users\Student\certadv\';
proc fedsql;
select *
from certadv.airports
order by ID
~~limit=5;~~
quit;
d. libname certadv v9 'C:\Users\Student\certadv\';
proc fedsql;
select*
from certadv.airports
order by ID
~~limit=5;~~
quit;

Both incorrect

Re: Another Typo ADVance certification Book chapter 6 Quiz6

SASJedi — Mon, 05 Oct 2020 13:18:28 GMT

Good eye! You are correct. Answer d. is identical to answer c., and both are wrong.

Answer d. should instead read:

d. libname certadv v9 'C:\Users\Student\certadv\';
proc fedsql;
select *
from certadv.airports
order by ID

limit 5;
quit;

topic Another Typo ADVance certification Book chapter 6 Quiz6 in SAS Certification

Another Typo ADVance certification Book chapter 6 Quiz6

Re: Another Typo ADVance certification Book chapter 6 Quiz6