Mindmajix

Advanced SAS Interview Questions

Recommended by 0 users

Advanced SAS Interview Questions

Q. What is the use of Macros in SAS?

Q. What different option in SAS Can be used to debug the Macro Program? 

Q. What is the use of Mprint Option in Macros? 

Q. What is Autocall Facility?

Q. What other SAS features do you use for error trapping and data validation?

Q. What is the application of Minoperator? Explain. 

Q. In How many ways we can create Macro variables in the Global Symbol Table?

Q. Define all ways to create Macro Variable ? 

Q. What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

Q. In How many ways we can create Macro variables in the Local Symbol Table?

Q. What is the difference between Global and Local Symbol Table? 

Q. What  is the difference between Call Symputx and Call Symput?

Q. Write the entire Syntax of Proc SQL? 

Q. What is the difference between Keyword parameters and Positional parameters?

Q. What is the use of Feedback Option? Where it can be applicable? 

Q. What is the difference between %NRST and %STR Functions?

Q. How would you create multiple observations from a single observation?

Q. Do you know the application of Validate key word in SQL? 

Q. What is Symget?

Q. Which Macro Functions are know as a Quoting function? 

Q. How to resolve Multiple Ampersand Symbols?

Q. What is the different between functions and PROCs that calculate the same simple descriptivestatistics?

Q. What is the difference between %STR and %NRSTR functions?

Q. Write a program to delete all the User Defined Macro variables form the Global Symbol Table?

Q. What is the use of %include? How we can see the source code in SAS? 

Q. Explain the Syntax of proc SQL?

Q. Using macro program how we can print all the dataset available in one SAS Library? 

Q. What is the difference between Sub-queries and SQL Views?

Q. How to delete the macro variable from global symbol table? How to delete all macro variable Automatically? 

Q. What are some good SAS programming practices for processing very large data sets?

Q. What is the difference between Inner join and Outer joins? Explain with examples?

Q. Specify the different types of joins in SQL? 

Q. How processing is different in SQL joins and Data step Merge? 

Q. How to vertically combine SAS Date Set by using Proc SQL and how it is different from Data Step Concatenation? 

Q. Can we use arrays in Proc SQL? 

Q. How to create a dataset using SQL Procedure? 

Q. In How many ways we can create SAS Data set by using proc SQL?
How can you perform the Benchmarking in SAS Programm? What are the advantages? 

Q. How to create Macro variables by Using Proc SQL?

Q. How many different ways we can create a INDEX in SAS? 

Q. How to save a program by using Data step?

Q. Why is SAS considered self-documenting?

Q. What are Hash Objects? Advantages of Hash Object. How to create Hash objects in SAS? 

Q. What is the difference between Joins and Merging?

Q. How to create a Dataset from user define format? 

Q. What do the SAS log messages “numeric values have been converted to character” mean? What arethe implications?

Q. What is Benchmarking in SAS?

Q. What is cntlin= option in format procedure? 

Q. Explain Indexes? In How many ways we can create Indexes?

Q. Write the syntax to make permanent formats by using from a SAS datasets? 

Q. Why is a STOP statement needed for the POINT= option on a SET statement?

Q. Explain SAS Views? In How many ways we can Create SAS views?

Q. What is the difference between SAS views and SAS datsets? 

Q. How does SAS handle missing values in: assignment statements, functions, a merge, an update, sortorder, formats, PROCs?

Q. What is the difference between libraries,Catalogs and dictionaries in SAS? 

0 Responses on Advanced SAS Interview Questions"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.