| Other SAS Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How would you code a merge that will keep only the
observations that have matches from both sets? | | 4 |
| How would you keep from overlaying the a SAS set with its
sorted version? | | 3 |
| Are you familiar with special input delimiters? How are they
used? | Accenture | 3 |
| . Which date advances a date, time or date/time value by a
given interval?
| | 6 |
| How can you put a "trace" in your program? | | 2 |
| hi i am nipun
can anybody tell me that
if a clinical sas programmer write the code and after
successfull execution
where do they store it.
how they submit tables to TL
how work is assigned to programmers
either both code, log, output to be submitted.
can any one tell me the process
| HSBC | 2 |
| How would you remove a format that has been permanently
associated with a variable?
________________
| TCS | 2 |
| 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 |
| Do you use PROC REPORT or PROC TABULATE? Which do you
prefer? Explain.
| | 3 |
| how do you read binary data in sas? | Satyam | 3 |
| For what purpose(s) would use the RETURN statement? | | 1 |
| how to intersect the tables by using PROC MIXED? | CitiGroup | 1 |
| Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH
REPEATS OF BY VARIABLE’.
| | 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 |
| what is Global Symbol table and Local symbol table?
| CitiGroup | 3 |
| data study;
input Subj : $3.
Group : $1.
Dose : $4.
Weight : $8.
Subgroup;
x= input(Weight,5.1);
datalines;
001 A Low 220 2
002 A High 90 1
003 B Low 193.6 1
004 B High 165 2
005 A Low 123.4 1
;
Why does X get truncated? X shows up as 22 instead of 220,9
instead of 90 and 19.8 instead of 198? This problem doesnt
happen with the values 193.6 and 123.4.
This does not happen if x is read on the 5. informat instead
of the 5.1 informat | | 2 |
| how do u validate sas program | Accenture | 2 |
| How the date 04oct1994 is stored in SAS,not only give the
answer explain in brief? | | 3 |
| What report output formats can you generate using SAS? | Accenture | 3 |
| Code a PROC MEANS that shows both summed and averaged
output of the data.
| | 3 |
| |
| For more SAS Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
