Preguntas de entrevistas para Analista Sas
439
Preguntas de entrevista para el cargo de Analista Sas compartidas por los candidatosPreguntas de entrevista principales
whats is the difference between merge and join .
4 respuestas↳
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. Menos
↳
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. Menos
↳
said merge requires sorting of data and join doesnt .
What is data type and what are types of data
3 respuestas↳
Was confused couldn't answer
↳
data type - Character & numeric type of data
↳
type of data - temporary & permanent
Swap two numbers without using a third variable
2 respuestas↳
Using arithmetic operations
↳
I have seen/heard the same feedback from too many people. Please Ameriprise do share the feedback with candidates as they also invest their time and you never know for some people this job can matter a lot. Menos
They never showed for the interview
2 respuestas↳
Typical. The owner has no respect for anyone.
↳
Yes, I agree, the owner is a total jerk.
Business case questions and scenarios
2 respuestas↳
Description: Building Standardized Reporting modules created from InfoMart data, provide management repost and dashboards to help Individual Business leading better manage the business. In BI Solution we analysis data as per business requirements which helps business to make key decisions. Menos
↳
Description: Building Standardized Reporting modules created from InfoMart data, provide management repost and dashboards to help Individual Business leading better manage the business. In BI Solution we analysis data as per business requirements which helps business to make key decisions. Menos
How do you add 2 missing values so that the result is zero?
2 respuestas↳
*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; Menos
↳
-2+2
Given a data on customer id, purchase dates and amount paid, how will you extract the last 2 purchases done by every customer?
1 respuestas↳
Data Purchase_data; infile cards; input customer_id purchase_dates ddmmyy10. amount_paid; Format purchase_dates date9.; cards; 101 01/02/2014 300 101 02/02/2014 500 101 03/02/2014 400 101 04/02/2014 600 102 01/02/2014 300 102 02/02/2014 500 102 03/02/2014 400 103 01/02/2014 400 103 02/02/2014 900 103 03/02/2014 500 103 04/02/2014 700 103 05/02/2014 300 ; run; proc sort data=Purchase_data; by customer_id descending purchase_dates; run; Data Last_Purchase; set Purchase_data; by customer_id; if first.customer_id=1 then count=1; else count+1; if count in(1,2); drop count; run; Menos
what is difference between proc merge and sql merge?
2 respuestas↳
main difference between data Merge and Proc sql in data merge you have to sort the data before joining but in Proc sql without sorting data you can join the tables. Menos
↳
ya in sql defualt merg ,print
1. Different ways to create macro 2. Data types in sas 3. Reporting tools. 4. SAS DI 5. Datawarehousing 6. Macro coding
2 respuestas↳
different ways of creating macro: %let statement call symput('macro_var_name',value) proc sql into: macro(par1=, par2=) -- while creating macro. Data types in sas: ch and numeric ar Menos
↳
%let statement %local %global Call execute('%let m=',|| variable ||); call symput('macro_var_name',value) proc sql into: macro(par1=, par2=) -- while creating macro. Menos