Sas Programmer Interview Questions
226
Sas Programmer interview questions shared by candidates
whats is the difference between merge and join .
4 Answers↳
Using join you can split lines (duplicate). For example, you have AETERM in Adverse Event, where AETERM = "headtoothache". It's 2 independent DECOD, and if you need to control it by MedDRA dictionary you need to split lines where AETERM in both lines equal to 'headtoothache' but AEDECOD in the first line equal to 'HEADACHE' and 'TOOTHACHE' in the second line. Less
↳
Merge:Merge is combining process which combine column wise i.e vertically, add different kind of variable names and datatypes, and Join: join is adding process which add rows wise i.e horizontal, add only same kind of variable names and datatypes. Less
↳
said merge requires sorting of data and join doesnt .
How do you add 2 missing values so that the result is zero?
2 Answers↳
*to add 2 missing values so that the result is zero can be achieved by using sum function with zero as extra argument. eg: data x; a = .; b = .; c = a + b + 0; /* even if you add zero, result is missing*/ d = sum(a,b,0); run; Less
↳
-2+2
1. Can you tell me a little about yourself? 2. How did you hear about the position? 3. What do you know about the company? 4. Why do you want this job? 5. Why should we hire you?
1 Answers↳
1. Can you tell me a little about yourself? 2. How did you hear about the position? 3. What do you know about the company? 4. Why do you want this job? 5. Why should we hire you? Less
tell me something which is not in your resume
1 Answers↳
mentioned about detailed internship and hobbies
Questions were typical interview questions, mostly relating to past work experience (particularly related to SAS knowledge/familiarity).
1 Answers↳
I actually did not have the required SAS background, but based on my skill set, they thought I would be better suited for a different role. EMMES was really accommodating, as I was able to speak to a separate department that same day for a different position. Less