Advanced SAS Interview Questions You'll Most Likely Be Asked

Price: $19.95


Qty. 
+-
Advanced SAS Interview Questions You'll Most Likely Be Asked is a perfect companion to stand ahead above the rest in today’s competitive job market. Rather than going through comprehensive, textbook-sized reference guides, this book includes only the information required immediately for job search to build an IT career. This book puts the interviewee in the driver's seat and helps them steer their way to impress the interviewer.
 
Table of Contents
1. PROC SQL
2. Horizontal Joins
3. Vertical Joins
4. Creating and Managing Tables
5. Creating and Managing Indexes
6. Creating and Managing Views
7. Processing using PROC SQL
8. Macro Variables
9. Macro Programs
HR Interview Questions
INDEX
 
Includes:
a) 215 Advanced SAS Interview Questions, Answers and proven strategies for getting hired as an IT professional
b) Dozens of examples to respond to interview questions
c) 77 HR Questions with Answers and proven strategies to give specific, impressive, answers that help nail the interviews
d) 2 Aptitude Tests download available on www.vibrantpublishers.com
 
Bisac
COM077000 COMPUTERS / Mathematical & Statistical Software
COM021030 COMPUTERS / Databases / Data Mining
COM021000 COMPUTERS / Databases / General
 
Sample from the book
(Below Questions and Answers are randomly taken from different pages of the book)
 
43: What is the main difference between NOEXEC option and VALIDATE keyword?
Answer:
The major difference between NOEXEC option and VALIDATE keyword is that VALIDATE keyword is applicable only to the SELECT statement following it whereas NOEXEC option is applicable to all the queries in the PROC SQL step.
 
125: Which statement is used to delete tables?
Answer:
DROP TABLE statement can be used to delete the tables.
Example: The following program illustrates the use of DROP TABLE statement to delete the table exam.set1.
proc sql;
drop table exam.set1;
quit;
 
188: Name some functions which cannot be used along with %SYSFUNC function.
Answer:
Some functions which cannot be used along with %SYSFUNC function are DIF, DIM, HBOUND, INPUT, LBOUND, PUT and SYMGET.
 
209: Explain the global symbol table.
Answer:
The global symbol table contains automatic macro variables as well as user defined macro variables which are created with the %LET statement outside the macro definition. This table is created when the SAS session starts and is deleted when the session ends. These macro variables in the global table can be accessed anytime during the session.
 
Tags
Advanced SAS Interview, SAS Programs, SAS Data Sets, SAS Reports, SAS functions, SAS PROC SQL, SAS Horizontal Joins, SAS Vertical Joins, SAS Creating Tables, SAS Managing Tables, SAS Creating Indexes, SAS Managing Indexes, SAS Creating Views, SAS Managing Views, SAS Processing PROC, SAS Macro Variable, SAS Macro Programs, HR Questions, job interview questions