| Other SAS Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Code a PROC SORT on a data set containing State, District
and County as the primary variables, along with several
numeric variables. | Accenture | 5 |
| What is the significance of the ‘OF’ in X=SUM (OF a1-a4,
a6, a9);?
| | 5 |
| What do you feel about hardcoding?
| Oracle | 4 |
| How would you delete observations with duplicate keys? | | 5 |
| data voter;
input Age Party : $1. (Ques1-Ques4)($1. + 1);
datalines;
23 D 1 1 2 2
45 R 5 5 4 1
67 D 2 4 3 3
39 R 4 4 4 4
19 D 2 1 2 1
75 D 3 3 2 3
57 R 4 3 4 4
;
Idont understand what the (Ques1-Ques4)($1. + 1) means.
I have seen (Ques1-Ques4)(4*$1.), but what is
(Ques1-Ques4)($1. + 1)?
Appreciate all help
Thanks | | 2 |
| how we can create optional or required parameters in SAS
macro... | TCS | 3 |
| Approximately what date is represented by SAS date value of
730 | | 7 |
| how do u validate sas program | Accenture | 2 |
| 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?
| | 2 |
| For what purpose(s) would use the RETURN statement? | | 1 |
| 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? | | 3 |
| 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 | 3 |
| what are the validation tools in sas? | | 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 | 2 |
| What is the difference between an informat and a format.
Name three informats or formats. | | 4 |
| How do you put an elephant in the refrigerator? | Oracle | 4 |
| tell me about intnx, intcx functions? | CitiGroup | 2 |
| How would you delete duplicate observations? | Accenture | 8 |
| How to select the observations randomly from a SAS dataset | | 5 |
| is there any difference between proc summary and proc means? | | 2 |
| |
| For more SAS Interview Questions Click Here |