| Other SAS Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| sas macros | | 6 |
| How would you delete observations with duplicate keys? | Accenture | 10 |
| how many types of MERGE? | CitiGroup | 12 |
| How would you code a merge that will keep only the
observations that have matches from both sets? | | 4 |
| how do you read binary data in sas? | Satyam | 3 |
| How did you use the round function?give an example(don't
say it will round to the nearest intger) eg1:round(84.55,.1)
=84.6 eg2:round(92.64,.1)=92.6,How it is happening like
this tell me the logic,that is how the round function works
when we have deimal values? | BoA | 2 |
| Which date functions advances a date time or date/time
value by agiven interval? | | 1 |
| Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH
REPEATS OF BY VARIABLE’.
| | 2 |
| Do you prefer Proc Report or Proc Tabulate? Why? | Oracle | 6 |
| The Lion King is hosting an animal conference. All the
animals in the world attend except one. Which animal does
not attend? | Oracle | 3 |
| What does error:1 mean? | Accenture | 2 |
| what is the difference between %put and symbolgen? | | 5 |
| If reading an external file to produce an external file,
what is the shortcut to write that record without coding
every single variable on the record? | Accenture | 2 |
| How would you generate 1000 observations from a normal
distribution with a mean of 50 and standard deviation of
20. How would you use PROC CHART to look at the
distribution? Describe the shape of the distribution. | | 1 |
| 1.How to draw pivot tables in Excel by using SAS and in
which version we can use VB script for to draw pivot
tables in Excel? Answer with example data.
2.What are the advantages of _NULL_ in Data steps? Can we
use _NULL_ in Proc steps also?
3. How to call the macro variable into Data Steps?
4. Can we draw pivot tables in Excel using Proc SQL?
Please post answers for the above questions with suitable
examples, and how to use VB script for Excel using SAS.
| | 1 |
| what is the need of INDEX in datasets? | CitiGroup | 3 |
| What SAS statements would you code to read an external raw
data file to a DATA step? | | 7 |
| what is the diff b/w verification validation in sas | SAS | 3 |
| what is TAB delimiter? explain about it? what will you do to
get TAB delimiter? | | 3 |
| How do you read in the variables that you need? | Accenture | 5 |
| |
| For more SAS Interview Questions Click Here |
Site Map
