| Other SAS Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| There are 200 observations in a dataset, i want to pull out
the observation no's 100, 150,180,190 by using Proc SQL? How
you can get it? | | 5 |
| how to write code for left outer join in SAs using datastep? | CitiGroup | 5 |
| How do you read in the variables that you need? | Accenture | 6 |
| The Lion King is hosting an animal conference. All the
animals in the world attend except one. Which animal does
not attend? | Oracle | 4 |
| Name statements that are recognized at compile time only? | | 4 |
| if x=round(26.3,10)-1 then x= how much and how explain? | BoA | 2 |
| What is difference between sas rename and lable? | | 1 |
| how many types of MERGE? | CitiGroup | 12 |
| How do you debug and test your SAS programs?
What can you learn from the SAS log when debugging?
How do you test for missing values?
How would you create multiple observations from a single
observation?
What are some good SAS programming practices for processing
very large data sets?
Briefly describe 5 ways to do a "table lookup" in SAS.
Why is SAS considered self-documenting?
Are you sensitive to code walk-throughs, peer review, or QC
review?
What other SAS features do you use for error trapping and
data validation?
How does SAS handle missing values in: assignment
statements, functions, a merge, an update, sort order,
formats, PROCs?
| | 2 |
| IS SAS COMPILER OR INTERPRETER? EXPLAIN? | HSBC | 2 |
| I have 2 data sets A & B. Both have a variable called Age in
them, each of them specifying a different functionality.
In my program I use bot these data sets. How do I specify
which Age variable I want to use? | | 2 |
| In the SAS Data step what is the difference between the
subsetting done by Where and subsetting done by If? | Cognizent | 3 |
| what is the main difference between rename and label? (don't
say that they both perform the same function). | Parexel | 9 |
| How do you read in the variables that you need? | | 5 |
| what is pdv? how it is related to input buffer in sas? | Satyam | 4 |
| What SAS statements would you code to read an external raw
data file to a DATA step? | | 7 |
| 1.How many ways are there to create variables?
2.What is CLM,how can we use it?
3.what are the advontages of data step?
4.what is the extension of editor window in SAS 9.1.3?
5.How do you copy a particular data set from one library to
another?
6.what is the use of double option?
7.Advontages of Proc Report?
8.what is the basic use of where statement?
9.How do you terminate the statments in SAS Programming?
10.What is the difference between symput and symget?
11.How would a identify the local and global variable?
can any one answer for the 4'th question | CitiGroup | 8 |
| I have 50 variables in one data set, In reports i want to
generate every 10 variables in one page how we will write
code in proc report. | | 3 |
| what is the diff b/w verification validation in sas | SAS | 3 |
| What is the Program Data Vector (PDV)? What are its functions? | Accenture | 5 |
| |
| For more SAS Interview Questions Click Here |