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
3 ways to show off your SAS skills

 

Why Get SAS Certified.jpg

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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