Quizzes
Take Quizzes
Animal
Nutrition
Love
Relationship
Computer
Sports
Society
Business
Geography
Language
Personality
Harry Potter
Movie
Television
Music
Online Exam
Health
Country
Art
Entertainment
Celebrity
Math
Game
Book
Fun
Science
Food
History
Education
All Topics
Create a Quiz
Quiz Maker
Training Maker
Survey Maker
Flashcards
Brain Games
See All
ProProfs.com
Search
Create A Quiz
Take Quizzes
Animal
Nutrition
Love
Relationship
Computer
Sports
Society
Business
Geography
Language
Personality
Harry Potter
Movie
Television
Music
Online Exam
Health
Country
Art
Entertainment
Celebrity
Math
Game
Book
Fun
Science
Food
History
Education
All Topics
Products
Quiz Maker
Training Maker
Survey Maker
Flashcards
Brain Games
See All
ProProfs.com
Quizzes
Quizzes
›
IT Certification
SAS Quiz 2 Practice Chapters 5-7
2 Questions
|
By Moxleyv | Updated: Mar 8, 2013
| Attempts: 78
Share
Quiz
Flashcard
Start
Share on Facebook
Share on Twitter
Share on Whatsapp
Share on Pinterest
Share on Email
Copy to Clipboard
Embed on your website
Question
1
/ 3
🏆
Rank #--
▾
0 %
0/100
Score
0/100
1.
Which statement correctly accesses an Excel file?
Libname xldat 'C:\Excel\example.xlsx.Sheet1';
Filename xldat 'C:\Excel\example.xlsx\Sheet1$';
Libname xldat 'C:\Excel\example.xlsx';
Filename xldat 'C:\Excel\example.xlsx';
Submit
Start Quiz
About This Quiz
Practice for the SAS Basic Certification exam
2.
What first name or nickname would you like us to use?
You may optionally provide this to label your report, leaderboard, or certificate.
2.
How would you create a list report of an Excel sheet?
Data work.new; infile xldat.'Sheet1$'; input var1 var2 var3; run; proc print data=work.new; ...
Data work.new; infile xldat.'Sheet1$'; input var1 var2 var3; run; proc print data=work.new; run;
Proc print data=xldat.'Sheet1$'; run;
Proc print data=xldat; sheet = 'Sheet1'; run;
Proc print data=xldat.'Sheet1$'n; run;
Submit
×
Thank you for your feedback!
View My Results
Related Quizzes
Chapter 8: Managing Processing Using Proc SQL
Chapter 8: Managing Processing Using Proc SQL
Thank you for your feedback!
Would you like to edit this question to improve it?
No thanks
Name:
Email:
Oops! Give us more information:
Incorrect Question
Incorrect Answer
Typos
I have a feedback
Submit
Please provide name and email to proceed.
Please provide correct email to proceed.
Please provide feedback.
Please select the option.
All (2)
Unanswered (
)
Answered (
)
Which statement correctly accesses an Excel file?
How would you create a list report of an Excel sheet?
X
OK
X
OK
Cancel
X
OK
Cancel
Your Rank: #-- / --
Leaderboard
✕