Sas Analyst Interview Questions
445
Sas Analyst 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 .
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
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.
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
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
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
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