| Other SAS Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is fact table and factless table? | | 1 |
| How would you delete duplicate observations? | | 7 |
| what are the new features included in the new version of
SAS i.e., SAS9.1.3? | Wockhardt | 4 |
| How could you generate test data with no input data?
| | 9 |
| Approximately what date is represented by SAS date value of
730 | | 5 |
| where will go the observations that were deleted by delete
statement? | | 1 |
| There is a field containing a date. It needs to be
displayed in the format
"ddmonyy" if it's before 1975,
"dd mon ccyy" if it's after 1985, and
as 'Disco Years' if it's between 1975 and 1985.
How would you accomplish this in data step code? Using
only PROC FORMAT
| D&B | 1 |
| How would you code a macro statement to produce information
on the SAS log? This statement can be coded anywhere. | | 7 |
| 1.What is the difference between _NULL_ , _ALL_, and _N_?
2.What are the uses of _NULL_ using in Data Steps? Can we
_NULL_ in Proc Steps also?
3.How do call the macro variable in Data Steps?
4.How to construct Pivot tables in Excel Using SAS?
| | 1 |
| What SAS statements would you code to read an external raw
data file to a DATA step? | Accenture | 5 |
| How experienced are you with customized reporting and use
of Data _Null_ features? | Oracle | 3 |
| How do you read in the variables that you need? | Accenture | 5 |
| What is the purpose of the trailing @? The @@? How would you
use them? | Accenture | 7 |
| How would you code a merge that will keep only the
observations that have matches from both sets? | | 4 |
| How would you code the criteria to restrict the output to be
produced? | | 6 |
| How would you keep from overlaying the a SAS set with its
sorted version? | | 3 |
| In a shcool there are 1000 students. After completion of
every test in 6 subjects , each subject teacher submit the
marks of every student at different times and loaded in the
database commonly. How will you seperate the top two
subject marks for each each studet using SAS? | | 3 |
| Does SAS ?Translate? (compile) or does it ?Interpret?? Explain. | | 6 |
| what is OLAP? | CitiGroup | 2 |
| CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE
REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER?
AND DEFERENCIATE THESE TWO ?
1). REPORT PROCEDURE
2). TABULATE PROCEDURE
| CybAge | 1 |
| |
| For more SAS Interview Questions Click Here |