| Other SAS Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| In this question, I rename the numeric variable phone to
numphone and then try use phone=put(numphone,comma16.) to
store the numeric value numphone as a string value in phone.
But I get a warning tha numphone already exists and in the
data sat phone doesnt exist and numphone is set to missing. Why?
data names_and_more;
input Name $20.
Phone : comma16.
Height & $10.
Mixed & $8.;
Name = tranwrd(Name,' ',' ');
rename phone = numphone;
phone = put(numphone,comma16.);
datalines;
Roger Cody 9,087,821,234 5ft. 10in. 50 1/8
Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2
Marco Polo 8,001,234,567 5Ft. 6in. 40
Brian Watson 5,183,551,766 5ft. 10in 89 3/4
Michael DeMarco 4,452,322,233 6ft. 76 1/3
;
| | 1 |
| When looking for data contained in a character string of 150
bytes, which function is the best to locate that data: scan,
index, or indexc? | Accenture | 2 |
| How would you code the criteria to restrict the output to be
produced? | Accenture | 5 |
| Name the option to produce a frequency line items rather
that a table.
| | 2 |
| what is the diff b/w verification validation in sas | SAS | 3 |
| If you need the value of a variable rather than the
variable itself what would you use to load the value to a
macro variable? | | 3 |
| Describe how you would pass data to macro. | | 3 |
| where will go the observations that were deleted by delete
statement? | | 1 |
| what other SAS features do you use for error trapping and
data validation? | | 1 |
| Are you familiar with special input delimiters? How are they
used? | Accenture | 3 |
| How do you put a giraffe into the refrigerator? | Oracle | 2 |
| How the date 04oct1994 is stored in SAS,not only give the
answer explain in brief? | | 3 |
| How would you include common or reuse code to be processed
along with your statements? | PSCI | 5 |
| Can you use a macro within another macro? If so how would
SAS know where the current acro ended and the new one
began? | | 1 |
| 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 | 2 |
| IS SAS COMPILER OR INTERPRETER? EXPLAIN? | HSBC | 2 |
| How would you code the criteria to restrict the output to be
produced? | | 6 |
| Does SAS ?Translate? (compile) or does it ?Interpret?? Explain. | | 8 |
| define table lookup and how may ways it can be
done...explian | | 3 |
| how to assign a macro value to a variable? | CitiGroup | 6 |
| |
| For more SAS Interview Questions Click Here |