Sas Analyst Interview Questions

445

Sas Analyst interview questions shared by candidates

Top Interview Questions

Sort: Relevance|Popular|Date
IQVIA
SAS Programmer was asked...12 May 2016

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 .

Show more responses
Optus Research & Analytics

What is data type and what are types of data

3 Answers

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 Answers

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. Less

Harmonia

They never showed for the interview

2 Answers

Typical. The owner has no respect for anyone.

Yes, I agree, the owner is a total jerk.

SAS Retail Services

Again, do you want this job or not.

2 Answers

Yea, I guess so.

Yes

Blue Star Infotech

Business case questions and scenarios

2 Answers

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. Less

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. Less

Target

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

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 Answers

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; Less

what is difference between proc merge and sql merge?

2 Answers

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. Less

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 Answers

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 Less

%let statement %local %global Call execute('%let m=',|| variable ||); call symput('macro_var_name',value) proc sql into: macro(par1=, par2=) -- while creating macro. Less

Viewing 1 - 10 of 445 interview questions

See Interview Questions for Similar Jobs

data analyststatistical analystsas programmerstatistical modeling analystanalytic consultantsas developerbusiness analyst capital markets

Glassdoor has 445 interview questions and reports from Sas analyst interviews. Prepare for your interview. Get hired. Love your job.