BookmarkSubscribeRSS Feed
rimal_mahesh
Fluorite | Level 6

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

1 REPLY 1
SASJedi
SAS Super FREQ

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;

Check out my Jedi SAS Tricks for SAS Users

Welcome to the Certification Community

 

This is a knowledge-sharing community for SAS Certified Professionals and anyone who wants to learn more about becoming SAS Certified. Ask questions and get answers fast. Share with others who are interested in certification and who are studying for certifications.To get the most from your community experience, use these getting-started resources:

Community Do's and Don'ts
How to add SAS syntax to your post
How to get fast, helpful answers

 

Why Get SAS Certified.jpg

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 657 views
  • 0 likes
  • 2 in conversation