Preguntas de entrevistas para Analista Sas

439

Preguntas de entrevista para el cargo de Analista Sas compartidas por los candidatos

Preguntas de entrevista principales

Ordenar: Relevancia|Popular|Fecha
IQVIA
Se le preguntó a SAS Programmer…12 de mayo de 2016

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 .

Mostrar más respuestas
Optus Research & Analytics

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

Ameriprise

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

Harmonia

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.

Blue Star Infotech

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

SAS Retail Services

Again, do you want this job or not.

2 respuestas

Yea, I guess so.

Yes

Target

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

Vodafone

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

SAS

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

Viendo 1 - 10 de 439 preguntas de entrevista

Consultar preguntas de entrevista para empleos similares

Glassdoor cuenta con 439 preguntas e informes de entrevistas obtenidos de entrevistas de Analista sas. Prepárate para la tuya. Obtén un empleo. Ama tu empleo.