SAS Programming Guidelines Interview Questions You'll Most Likely Be Asked
()
About this ebook
- 215 SAS Programming Guidelines Interview Questions
- 78 HR Interview Questions
- Real life scenario-based questions
- Strategies to respond to interview questions
- 2 Aptitude Tests
SAS Program
Read more from Vibrant Publishers
Operations and Supply Chain Management Essentials You Always Wanted To Know: Self Learning Management Rating: 0 out of 5 stars0 ratingsDiversity in the Workplace Essentials You Always Wanted To Know: Self Learning Management Rating: 5 out of 5 stars5/5HR Analytics Essentials You Always Wanted To Know: Self Learning Management Rating: 0 out of 5 stars0 ratingsStakeholder Engagement Essentials You Always Wanted To Know: Self Learning Management Rating: 5 out of 5 stars5/5GRE Master Wordlist: 1535 Words for Verbal Mastery: Test Prep Series Rating: 4 out of 5 stars4/5Digital SAT Reading and Writing Practice Questions: Test Prep Series Rating: 5 out of 5 stars5/5Core Java Interview Questions You'll Most Likely Be Asked: Job Interview Questions Series Rating: 4 out of 5 stars4/5Business Strategy Essentials You Always Wanted To Know: Self Learning Management Rating: 5 out of 5 stars5/5GRE Reading Comprehension: Detailed Solutions to 325 Questions: Test Prep Series Rating: 5 out of 5 stars5/5GMAT Analytical Writing: Solutions to the Real Argument Topics: Test Prep Series Rating: 4 out of 5 stars4/5Leadership Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsGRE Text Completion and Sentence Equivalence Practice Questions: Test Prep Series Rating: 4 out of 5 stars4/5Financial Accounting Essentials You Always Wanted to Know: 5th Edition: Self Learning Management Rating: 0 out of 5 stars0 ratingsFinancial Management Essentials You Always Wanted to Know: 5th Edition: Self Learning Management Rating: 0 out of 5 stars0 ratingsWriting Impressive College Essays: Test Prep Series Rating: 0 out of 5 stars0 ratingsGRE Words In Context: The Complete List: Test Prep Series Rating: 5 out of 5 stars5/5Project Management Essentials You Always Wanted To Know: Self Learning Management Rating: 0 out of 5 stars0 ratingsInnovative Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsData Analytics Essentials You Always Wanted To Know: Self Learning Management Rating: 0 out of 5 stars0 ratingsPrinciples of Management Essentials You Always Wanted To Know: Self Learning Management Rating: 0 out of 5 stars0 ratingsHuman Resource Management Essentials You Always Wanted To Know: Self Learning Management Rating: 0 out of 5 stars0 ratingsGRE Verbal Reasoning Supreme: Study Guide with Practice Questions: Test Prep Series Rating: 4 out of 5 stars4/5Time Management Essentials You Always Wanted To Know: Self Learning Management Rating: 0 out of 5 stars0 ratingsBusiness Law Essentials You Always Wanted To Know: Self Learning Management Rating: 0 out of 5 stars0 ratingsLeadership Essentials You Always Wanted To Know: Self Learning Management Rating: 0 out of 5 stars0 ratingsGRE Analytical Writing: Solutions to the Real Essay Topics - Book 1: Test Prep Series Rating: 5 out of 5 stars5/5Winning Strategies For ACT Essay Writing: With 15 Sample Prompts: Test Prep Series Rating: 5 out of 5 stars5/5HR Interview Questions You'll Most Likely Be Asked: Job Interview Questions Series Rating: 0 out of 5 stars0 ratingsDigital Marketing Essentials You Always Wanted To Know: Self Learning Management Rating: 0 out of 5 stars0 ratingsDecision Making Essentials You Always Wanted To Know: Self Learning Management Rating: 0 out of 5 stars0 ratings
Related to SAS Programming Guidelines Interview Questions You'll Most Likely Be Asked
Titles in the series (33)
Advanced JAVA Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsJava / J2EE Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsC & C++ Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsSQL Server Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsData Structures & Algorithms Interview Questions You'll Most Likely Be Asked Rating: 1 out of 5 stars1/5C# Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsCORE JAVA Interview Questions You'll Most Likely Be Asked Rating: 4 out of 5 stars4/5Hadoop BIG DATA Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsHibernate, Spring & Struts Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsORACLE PL/SQL Interview Questions You'll Most Likely Be Asked Rating: 5 out of 5 stars5/5Automated Software Testing Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsSoftware Testing Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsCCNA Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsSAP HANA Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsJavaScript Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsAdvanced C++ Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsJSP-Servlet Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsOperating Systems Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsSAS Programming Guidelines Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsPython Interview Questions You'll Most Likely Be Asked Rating: 2 out of 5 stars2/5Advanced SAS Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsBase SAS Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsSAS Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsUNIX Shell Programming Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsJava/J2EE Design Patterns Interview Questions You'll Most Likely Be Asked: Second Edition Rating: 0 out of 5 stars0 ratingsIBM WebSphere Application Server Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsHR Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsLinux System Administrator Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsCloud Computing Interview Questions You'll Most Likely Be Asked: Second Edition Rating: 0 out of 5 stars0 ratings
Related ebooks
Base SAS Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsPractical and Efficient SAS Programming: The Insider's Guide Rating: 0 out of 5 stars0 ratingsFundamentals of Programming in SAS: A Case Studies Approach Rating: 0 out of 5 stars0 ratingsSAS Certified Professional Prep Guide: Advanced Programming Using SAS 9.4 Rating: 1 out of 5 stars1/5SAS Certified Specialist Prep Guide: Base Programming Using SAS 9.4 Rating: 4 out of 5 stars4/5Exercises and Projects for The Little SAS Book, Sixth Edition Rating: 0 out of 5 stars0 ratingsEnd-to-End Data Science with SAS: A Hands-On Programming Guide Rating: 0 out of 5 stars0 ratingsSAS Programming in the Pharmaceutical Industry, Second Edition Rating: 5 out of 5 stars5/5Predictive Modeling with SAS Enterprise Miner: Practical Solutions for Business Applications, Third Edition Rating: 0 out of 5 stars0 ratingsMachine Learning with SAS Viya Rating: 0 out of 5 stars0 ratingsSAS Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsSAS Visual Analytics for SAS Viya Rating: 0 out of 5 stars0 ratingsThe Data Detective's Toolkit: Cutting-Edge Techniques and SAS Macros to Clean, Prepare, and Manage Data Rating: 0 out of 5 stars0 ratingsUnstructured Data Analysis: Entity Resolution and Regular Expressions in SAS Rating: 0 out of 5 stars0 ratingsDeep Learning for Numerical Applications with SAS Rating: 0 out of 5 stars0 ratingsSegmentation Analytics with SAS Viya: An Approach to Clustering and Visualization Rating: 0 out of 5 stars0 ratingsLearn Hadoop in 24 Hours Rating: 0 out of 5 stars0 ratingsThe SAS Programmer's PROC REPORT Handbook: ODS Companion Rating: 0 out of 5 stars0 ratingsPROC SQL: Beyond the Basics Using SAS, Third Edition Rating: 0 out of 5 stars0 ratingsSAS Macro Programming Made Easy, Third Edition Rating: 3 out of 5 stars3/5Cody's Data Cleaning Techniques Using SAS, Third Edition Rating: 5 out of 5 stars5/5Learning SAS by Example: A Programmer's Guide, Second Edition Rating: 3 out of 5 stars3/5SAS Statistics by Example Rating: 5 out of 5 stars5/5SAS Functions by Example, Second Edition Rating: 1 out of 5 stars1/5Advanced SAS Interview Questions You'll Most Likely Be Asked Rating: 0 out of 5 stars0 ratingsImplementing CDISC Using SAS: An End-to-End Guide, Revised Second Edition Rating: 0 out of 5 stars0 ratingsSAS Programming with Medicare Administrative Data Rating: 5 out of 5 stars5/5
Applications & Software For You
Adobe Illustrator: A Complete Course and Compendium of Features Rating: 0 out of 5 stars0 ratingsExcel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Learn to Code. Get a Job. The Ultimate Guide to Learning and Getting Hired as a Developer. Rating: 5 out of 5 stars5/5How to Create Cpn Numbers the Right way: A Step by Step Guide to Creating cpn Numbers Legally Rating: 4 out of 5 stars4/5Logic Pro X For Dummies Rating: 0 out of 5 stars0 ratingsGarageBand For Dummies Rating: 5 out of 5 stars5/5Six Figure Blogging In 3 Months Rating: 4 out of 5 stars4/5Blender 3D Basics Beginner's Guide Second Edition Rating: 5 out of 5 stars5/5Sound Design for Filmmakers: Film School Sound Rating: 5 out of 5 stars5/5The Best Hacking Tricks for Beginners Rating: 4 out of 5 stars4/5Gray Hat Hacking the Ethical Hacker's Rating: 5 out of 5 stars5/5How Do I Do That In InDesign? Rating: 5 out of 5 stars5/5Adobe Illustrator CC For Dummies Rating: 5 out of 5 stars5/5Start Your Own Podcast Business: Your Step-By-Step Guide to Success Rating: 5 out of 5 stars5/5GarageBand Basics: The Complete Guide to GarageBand: Music Rating: 0 out of 5 stars0 ratingsSynthesizer Cookbook: How to Use Filters: Sound Design for Beginners, #2 Rating: 3 out of 5 stars3/5Adobe Photoshop: A Complete Course and Compendium of Features Rating: 5 out of 5 stars5/5The Most Concise Step-By-Step Guide To ChatGPT Ever Rating: 3 out of 5 stars3/5iPhone Photography For Dummies Rating: 0 out of 5 stars0 ratingsSketchUp Success for Woodworkers: Four Simple Rules to Create 3D Drawings Quickly and Accurately Rating: 2 out of 5 stars2/5Blueprints to Building Your Own Voice-Over Studio Rating: 0 out of 5 stars0 ratingsAdobe Premiere Pro: A Complete Course and Compendium of Features Rating: 0 out of 5 stars0 ratingsAdobe InDesign CC: A Complete Course and Compendium of Features Rating: 0 out of 5 stars0 ratings2022 Adobe® Premiere Pro Guide For Filmmakers and YouTubers Rating: 5 out of 5 stars5/5Book Design Made Simple Rating: 0 out of 5 stars0 ratings80 Ways to Use ChatGPT in the Classroom Rating: 5 out of 5 stars5/5
Related categories
Reviews for SAS Programming Guidelines Interview Questions You'll Most Likely Be Asked
0 ratings0 reviews
Book preview
SAS Programming Guidelines Interview Questions You'll Most Likely Be Asked - Vibrant Publishers
SAS Programming Guidelines
Interview Questions
You'll Most Likely Be Asked
Job Interview Questions Series
www.vibrantpublishers.com
*****
SAS Programming Guidelines Interview Questions You'll Most Likely Be Asked
Copyright 2021, By Vibrant Publishers, USA. All rights reserved. No part of this publication may be reproduced or distributed in any form or by any means, or stored in a database or retrieval system, without the prior permission of the publisher.
This publication is designed to provide accurate and authoritative information in regard to the subject matter covered. The author has made every effort in the preparation of this book to ensure the accuracy of the information. However, information in this book is sold without warranty either expressed or implied. The Author or the Publisher will not be liable for any damages caused or alleged to be caused either directly or indirectly by this book.
Vibrant Publishers books are available at special quantity discount for sales promotions, or for use in corporate training programs. For more information please write to [email protected]
Please email feedback/corrections (technical, grammatical or spelling) to [email protected]
To access the complete catalogue of Vibrant Publishers, visit www.vibrantpublishers.com
*****
Table of Contents
1. Efficient SAS Programming
2. Memory Usage
3. Data Storage Space
4. Best Practices
5. Sorting Strategies
6. Samples
7. Using Indexes
8. Combining Data Vertically
9. Combining Data Horizontally
10. Lookup Tables
11. Formatting Data
12. Tracking Changes
HR Interview Questions
INDEX
*****
SAS Programming Guidelines
Interview Questions
Review these typical interview questions and think about how you would answer them. Read the answers listed; you will find best possible answers along with strategies and suggestions.
*****
Efficient SAS Programming
1: How do you achieve scalability in SAS programming?
Answer:
SAS program scalability can be achieved in 2 ways - by scaling up and scaling out. Scalability is ensuring the lowest time to solution, especially for the most vital tasks. Typically, when you want to speed up the task completion, you either try to complete multiple processes at the same time or distribute the task across various processors and do parallel processing. This, sometimes, involve overlapping of certain processes. Scaling up requires better hardware that is capable of multiprocessing which is known as symmetric multiprocessing or SMP. Scaling out requires more servers that can handle distributed processing.
2: How do SQL Views help better efficiency?
Answer:
A View typically consists of a subset of the entire table and hence is more efficient as it accesses a smaller set of data which is required. View also lets you hide the sensitive columns and complex queries from the user by choosing only what needs to be shown. Views always fetch fresh data from the table as they do not store any data.
3: What do you know about the SPD Engine?
Answer:
The SPD Engine or the SAS Scalable Performance Data Engine is developed for SAS 9 to speed up the processing of large data sets by splitting them into smaller physical files called partitions. There are several parallel processors that have exclusive access to each partition and process them in parallel using threads. Partitions are created when the SAS data sets are created. When a Where clause is mentioned it is split across the partitions and processed in parallel. Data blocks are also read in parallel. Multiple connections are created based on the partitions which further reduces the I/O bottlenecks. The SPD Engine also does an implicit sort if the query contains a by clause.
4: What resources are used to run a SAS program?
Answer:
The six resources used to run a SAS program are:
a) Programmer time: The amount of time taken by the programmer for writing, testing and maintaining the program
b) Real time: The time elapsed while executing a job
c) CPU time: The amount of time the CPU takes to perform a task. The task can be reading data, writing data, calculations or implementation of a logic
d) Memory: The work area memory space used for holding executable programs, data, etc
e) Data storage space: The disk space for storing the data. This is measured in terms of bytes, kilobytes, gigabytes etc.
f) I/O: The read and write operations performed to movie data from the memory to any output device, and vice versa
5: List the factors that need to be considered while assessing the technical environment.
Answer:
The four factors that need to be considered while assessing a technical environment are:
a) Hardware: Available memory, number of CPU’s, number of devices connected, network bandwidth, I/O bandwidth, and capability to upgrade
b) Operating environment: The resource allocation & I/O methods
c) System load: This includes the number of users sharing the system, the network traffic, and the predicted increase in load
d) SAS environment: includes all SAS software products installed, number of CPU’s, and memory allocated for SAS programming
6: Explain the functionality of the system option STIMER in the Windows environment.
Answer:
STIMER option in the Windows environment specifies that CPU time and real time statistics are tracked and written to the SAS log throughout the SAS session.
Example: The following line of code turns on the STIMER option options STIMER;
7: What is the function of the option FULLSTIMER in the Windows operating environment?
Answer:
FULLSTIMER option in the Windows environment specifies that all the available resource usage statistics needs to be tracked and written to SAS log throughout the SAS session.
Example:
options FULLSTIMER;
8: Explain the MEMRPT option.
Answer:
The MEMRPT option in the z/OS environment specifies that the memory usage statistics are tracked and written to SAS log throughout the SAS session. This is not available as a separate option in the Windows operating environment.
9: While benchmarking the programming techniques in SAS, why is it necessary to execute each programming technique in separate sessions?
Answer:
It is always necessary to execute each programming technique in separate SAS sessions while benchmarking them the first time a program is read because the operating system might load the code into the cache and retrieve it from the cache when it is referenced. This takes less time. The resource usage necessary to perform this action is referred to as overhead. Using separate sessions minimize the effect of overhead on resource statistics.
10: While doing benchmark tests, when is it advisable to run the code for each programming technique several times?
Answer:
It is advised to run the code for each programming technique several times while benchmarking tests if the system is executing other jobs at the same time. Running the code several times reduces variations in the resource consumption associated with the task and so the average resource usage is known.
11: How do you turn off the FULLSTIMER option?
Answer:
The FULLSTIMER option can be turned off with the following line of code.
options nofullstimer;
12: What steps can be taken to reduce the programmer time?
Answer:
Programmer Time is the amount of time required for the programmer to determine the specifications, write, submit, test and maintain the program. It is difficult to calculate the exact time, but it can be reduced by the use of well-documented programming practices and reuse of SAS code modules.
*****
Memory Usage
13: What is PDV? How does it work?
Answer:
PDV or Program Data Vector is a memory area created after the input buffer is created. Two extra variables _N_ and _Error_ are created by the SAS engine during compilation. These variables are used for processing but never written into the data set. SAS creates a PDV for each observation.
14: How would you choose between Data Step and Proc SQL?
Answer:
With small data sets, Proc SQL works better since it loads the entire data set into the memory and works with the data. So there’s less need to go back and forth into the database. But with large data sets Data Step will work better as loading the entire data set with Proc SQL will block a huge chunk of memory. Data Step will always take one record at a time and hence, the number of records or large volume of data will not matter as long as the database connectivity remains good.
15: Explain memory management in SAS.
Answer:
SAS, unlike Java and .Net, does not have garbage collection for memory management. But it does accomplish the job with a series of instructions called steps. Memory is allocated when the step begins and released when the step completes. This way, there’s no memory loosely allocated during the runtime. When dealing with large volumes of data, there may be cases when ample memory is not available. In such cases, SAS pushes an error message that memory not available, which is logged for reference. The hash objects in SAS lets you handle considerable amount of objects quickly. The Data Step is also efficient in memory management as it takes only one record at a time. Since most of the SAS programs depend upon a Work Area which they use to store objects temporarily, this area typically runs out of memory which needs to be handled efficiently.
16: What is the sequence of action performed in the background while trying to create a data set from another data set?
Answer:
While creating a data set from another data set the following actions take place in the background
a) The data gets copied from the input data set to a buffer in memory
b) From the input buffer an observation at a time is written to PDV (Program Data Vector)
c) Each observation from PDV is written to output buffer when processing is complete
d) The contents of output buffer are written to disk when the buffer is full.
17: Define PAGE and PAGESIZE.
Answer:
A PAGE is a unit that indicates the data transfer between a storage device and PAGESIZE is the amount of data that can be transferred to one buffer in a single I/O operation.
18: What procedure is used to indicate the PAGESIZE of a data set?
Answer:
The Contents procedure is used to know the PAGESIZE associated with a data set.
Example: The following Contents procedure issues a message to SAS log indicating the PAGESIZE associated with the data set exam.clinic1. This also gives the number of data set pages.
Proc contents data = exam.clinic1;
run;
19: Is it